I have 3 tables which info are related.
For example, table 1 must have a record which would have many record in table 2. In turn each record in table 2 would have many record in table 3.
At present, the way I set it is a form for table 1 which then open up a second form for input which in turn could open up a 3 form for table 3.
However, user want the field to be in combo box to select and also add to table if record not existed. In order to achieve that for the first table, I would do the combo box but how do I do it for 2nd and 3rd field as each in depended on what is selected on the previous field
For example
Field one List on field 2 (table 2) List on field 3 (table 3)
Meat beef siron
rump
pork tendorloin
lean
bacon
Fruits Apple Golden delicouse red
Golden delicious green
Pear conference
If user select from the drop down box meat then on the second box, I need to populate beef and port and if user select beef on 2nd field, need to show siron, rump on the 3rd field dropdown box.
For example, table 1 must have a record which would have many record in table 2. In turn each record in table 2 would have many record in table 3.
At present, the way I set it is a form for table 1 which then open up a second form for input which in turn could open up a 3 form for table 3.
However, user want the field to be in combo box to select and also add to table if record not existed. In order to achieve that for the first table, I would do the combo box but how do I do it for 2nd and 3rd field as each in depended on what is selected on the previous field
For example
Field one List on field 2 (table 2) List on field 3 (table 3)
Meat beef siron
rump
pork tendorloin
lean
bacon
Fruits Apple Golden delicouse red
Golden delicious green
Pear conference
If user select from the drop down box meat then on the second box, I need to populate beef and port and if user select beef on 2nd field, need to show siron, rump on the 3rd field dropdown box.
