2. PHPRunner General questions
  3. [SOLVED]  Structure of Data
This topic is locked
[SOLVED]

 Structure of Data

 		10/25/2019 1:58:53 AM
PHPRunner General questions
J
 justinkongyt author

Hi everyone,
May I ask if this way of doing the table is possible?
Example:
I have 3 tables:
Mobile

Phone

Email

All 3 tables only have 1 field each and that field is the primary key to prevent duplication
I have another table called Customer. In this table:
Name

Mobile

Phone

Email

Remarks
Question:

Is it possible that in the Customer (ADD Menu), I can type in Name, Mobile, Phone, Email and Remarks.
The unique thing is that when I key in Mobile, Phone and Email in this screen, these data get saved in to Mobile Table, Phone Table and Email Table respectively. This is to prevent duplication. Also while I type in these 3 fields, it can autocomplete if there is a match.
Appreciate if someone can point me in the right direction.
Thank you
HJB 10/25/2019

https://xlinesoft.com/phprunner/docs/edit_as_settings.htm
... second screenshot inside the URL content above refers,

here the check box named "Prevent Duplicate Values" in particular.
Say, you only need ONE customer table with "checked box" in regard

to "Prevent Duplicate Values" phone, mail, fax etc pp field entries.
J
 		justinkongyt author 10/30/2019



https://xlinesoft.com/phprunner/docs/edit_as_settings.htm
... second screenshot inside the URL content above refers,

here the check box named "Prevent Duplicate Values" in particular.
Say, you only need ONE customer table with "checked box" in regard

to "Prevent Duplicate Values" phone, mail, fax etc pp field entries.



Thank you! I will check it out