Hi,
I have 2 databases, one has the following fields
#Database 1#
Delivery ID
Name of company
items delivered
#Database 2#
The second database is as follows
Delivery ID
Item ID
Name of company
I want it so that when someone enters the relevant info into a form attached to #database 1# it stores it in that database and then dependant on the number of items create that many entries into database 2- with the delivery number and then an ID number for each item.
so say i put this into database1
Delivery ID: 123123
Name of company: joeyjays
items delivered: 5
I click enter and then this will be entered into database2
Delivery ID Item ID Name of company
123123 1245 joeyjays
123123 1246 joeyjays
123123 1247 joeyjays
123123 1248 joeyjays
123123 1249 joeyjays
Im sorry if it sounds confusing
Thanks in advance....
I have 2 databases, one has the following fields
#Database 1#
Delivery ID
Name of company
items delivered
#Database 2#
The second database is as follows
Delivery ID
Item ID
Name of company
I want it so that when someone enters the relevant info into a form attached to #database 1# it stores it in that database and then dependant on the number of items create that many entries into database 2- with the delivery number and then an ID number for each item.
so say i put this into database1
Delivery ID: 123123
Name of company: joeyjays
items delivered: 5
I click enter and then this will be entered into database2
Delivery ID Item ID Name of company
123123 1245 joeyjays
123123 1246 joeyjays
123123 1247 joeyjays
123123 1248 joeyjays
123123 1249 joeyjays
Im sorry if it sounds confusing
Thanks in advance....