G
Gillian
I have a simple database of products and suppliers and a couple of small
lookup tables. The products and suppliers tables are linked in a
relationship using the supplier's Sage code and this field is also used as a
lookup from suppliers when adding data to products. When I set up new
products it is quite likely that there will be some new suppliers also. In
these cases I would like to be able to enter the new supplier Sage code in
the products table for the new product item and for the supplier table to
automatically create a new record with the new supplier Sage code. I would
then go and complete the new supplier table record at a later date. How do I
go about doing this?
lookup tables. The products and suppliers tables are linked in a
relationship using the supplier's Sage code and this field is also used as a
lookup from suppliers when adding data to products. When I set up new
products it is quite likely that there will be some new suppliers also. In
these cases I would like to be able to enter the new supplier Sage code in
the products table for the new product item and for the supplier table to
automatically create a new record with the new supplier Sage code. I would
then go and complete the new supplier table record at a later date. How do I
go about doing this?