L'apprentis
Redcifer
- Local time
- Today, 15:22
- Joined
- Jun 22, 2005
- Messages
- 177
Hi,
Here is a snapshot of my relationship; I am not entirely sure i am doing it right. Got three tables linked together as shown (Drawing, Line Configuration, Line).
My main form where I would enter the data would be link to the Drawing Table. Each drawing can have 1 to 6 lines, all lines specification (Dimension and type) should already be recorded in the Table line. I want to record which type and how many of those lines there is in each drawing.
My method would be as follow: For each new drawing I can add a new line via comboboxe, enter the no used for that drawing and then, proceed to next line if needed.
I am getting confused because my form is not working, I have been trying to use a query with data from the three tables linked to a subform.
I am not sure i am heading in the right direction to do what I am trying to do.
Not sure i explained myself very clearly but if anybody could give me a hand I would be really gratefull.
Here is a snapshot of my relationship; I am not entirely sure i am doing it right. Got three tables linked together as shown (Drawing, Line Configuration, Line).
My main form where I would enter the data would be link to the Drawing Table. Each drawing can have 1 to 6 lines, all lines specification (Dimension and type) should already be recorded in the Table line. I want to record which type and how many of those lines there is in each drawing.
My method would be as follow: For each new drawing I can add a new line via comboboxe, enter the no used for that drawing and then, proceed to next line if needed.
I am getting confused because my form is not working, I have been trying to use a query with data from the three tables linked to a subform.
I am not sure i am heading in the right direction to do what I am trying to do.
Not sure i explained myself very clearly but if anybody could give me a hand I would be really gratefull.
