|
Hello all, I have multiple tables. They all are related by foreign
keys. What I am trying to create different forms that will interact
with my tables. My plan is to design a form, I will enter the
information and then click on a button that will take me to my next
form. This next form should already have the ID of my other form, so I
will enter the information that I need for that one and so on. I
already have the tables, I tried creating one form, put the button,
this button will open my next form BUT the information from my previous
form is not in there. When I go and check my table the information is
there. So I really do not how to make this relationship...the
relationship b/w my tables looks good
This is an example of what I am trying to do:
Form A
Class_id: (AutoNumber) ---->this will create an automatic ID so lets
say its = 23
Tag#: 2390429034
Bus Team: test
Service: test2
Then I click on the button that says "Form B"
Form B
Item id_: (AutoNumber) -----same procedure
Class_id: 23
Description: test3
..
..
So this is What I want. My Class_id to be display in the next form, so
everything is in a relationship
Please help me
Thank you |