Delivery split

[ltpr1]

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....

 

[Rabbie]

Do you mean Databases or Tables??

 

[ltpr1]

HI,

Yea sorry i ment tables,

It is 2 tables in one database.

Thanks

 

[ltpr1]

HI I have attached a demo of the file, hope this helps