I have not been successful in entering the correct words for the search results I am needing. What I want to do is either find code that I can modify or a video that shows how to set up a routine that will operate on MySQL environment. The approach will be similar to creating a billing application set. I don't want to either re-enter data or store data twice.
Have Table 1 (Standard, repeatable data that will be used over and over)
Cust ID
Name1
Name 2
Addr1
Addr2
City
ST
etc.
Table 2 (Variable data similar to items on an invoice)
Record ID
Cust ID
Data 1
Data 2
Data 3
Data 4
Table 3 (will contain data for Table 2 data field "Data 1")
Table 4 (will contain data for Table 2 data field "Data 2")
Table 5 (will contain data for Table 2 data field "Data 3")
Table 6 (will contain data for Table 2 data field "Data 4")
What I would like to be able to do is when I am entering info into Table 2 is to be able to look-up info from Table 1 in the Cust ID field and do the same for other fields in Table 2 that are able to search from other Tables (not Table 1 or Table 2).
Consider Table 1 to be similar to basic customer information but Table 2 will contain information from 3-4 different tables (different fields will come from different tables.)
The fields in Table 2 will contain unique information specific to that field alone.
If I were developing a .dbf app on a desktop I would organize it as a "SET".
There are probably a lot of examples on the Alpha site but I must be using the wrong key words.
Really appreciate your help.
Mike
Have Table 1 (Standard, repeatable data that will be used over and over)
Cust ID
Name1
Name 2
Addr1
Addr2
City
ST
etc.
Table 2 (Variable data similar to items on an invoice)
Record ID
Cust ID
Data 1
Data 2
Data 3
Data 4
Table 3 (will contain data for Table 2 data field "Data 1")
Table 4 (will contain data for Table 2 data field "Data 2")
Table 5 (will contain data for Table 2 data field "Data 3")
Table 6 (will contain data for Table 2 data field "Data 4")
What I would like to be able to do is when I am entering info into Table 2 is to be able to look-up info from Table 1 in the Cust ID field and do the same for other fields in Table 2 that are able to search from other Tables (not Table 1 or Table 2).
Consider Table 1 to be similar to basic customer information but Table 2 will contain information from 3-4 different tables (different fields will come from different tables.)
The fields in Table 2 will contain unique information specific to that field alone.
If I were developing a .dbf app on a desktop I would organize it as a "SET".
There are probably a lot of examples on the Alpha site but I must be using the wrong key words.
Really appreciate your help.
Mike
Comment