J
JCrowe
Hi,
I have form that ties 3 tables together.
Table 1 - Publication Information
Table 2 - Invoicing Information
Table 3 - Check In / Check Out Information
The tables are joined using the "PublicationID" as the
primary key. When I need to enter a new publication I
simply enter a new (next in order) PublicationID number.
For this example lets say the number "42" . If the number
had not been used before I get a clean form to begin data
entry. If it has been used before I get the info from the
Invoicing table and the Check In table BUT NO info from
the Publication table which is the main table....Make
sense ? Is there a way to have this information displayed
as well ? If so where would I look to do this at ?
Thanks,
JCrowe
I have form that ties 3 tables together.
Table 1 - Publication Information
Table 2 - Invoicing Information
Table 3 - Check In / Check Out Information
The tables are joined using the "PublicationID" as the
primary key. When I need to enter a new publication I
simply enter a new (next in order) PublicationID number.
For this example lets say the number "42" . If the number
had not been used before I get a clean form to begin data
entry. If it has been used before I get the info from the
Invoicing table and the Check In table BUT NO info from
the Publication table which is the main table....Make
sense ? Is there a way to have this information displayed
as well ? If so where would I look to do this at ?
Thanks,
JCrowe