frostysnoman
New member
- Local time
- Yesterday, 21:07
- Joined
- Oct 11, 2004
- Messages
- 6
Hi everyone,
This might be very simple, but I can't see to figure it out. I need to relate two tables, with a third. I have one table called data, one called all, and one called components. Rows in data need to be linked to some rows in all. Using the old autoDB, you can create a DB for workorders, this has a similar feature, IE the parts linked to workorders. Please help me figure out how to populate components ( has many 2 one link with primary keys of other two tables), so that the rows of all can be components of data. The goal of the form is to take the ID number from the data.* displayed, and populate the components table, at components.ProjectID, and then the subform will have the all information to populate components.componentID. I would also like to figure out why my subform only acts as a dropdown in datasheet view, with no possibiliy of adding multiple records. Please Help........
This might be very simple, but I can't see to figure it out. I need to relate two tables, with a third. I have one table called data, one called all, and one called components. Rows in data need to be linked to some rows in all. Using the old autoDB, you can create a DB for workorders, this has a similar feature, IE the parts linked to workorders. Please help me figure out how to populate components ( has many 2 one link with primary keys of other two tables), so that the rows of all can be components of data. The goal of the form is to take the ID number from the data.* displayed, and populate the components table, at components.ProjectID, and then the subform will have the all information to populate components.componentID. I would also like to figure out why my subform only acts as a dropdown in datasheet view, with no possibiliy of adding multiple records. Please Help........
Last edited:
