Adding multiple records to a table at once

[Boto]

Edit: FM7pro on Max OS X Panther

Okay this is the situation

1/ table with an offer, this one has an OfferID, a Car ID, MotorOption, a Date etc., the CarID points to the car in question

2/ table with the car/motortype price list, CarID, MotorOption and Price

3/ table with rows on the offer, so this one has OfferID, RowID, OptionID, totalprice, quantity

4/ table with Options, has OptionID, OptionSpecs ans Price

I want to make a new offer, by pressing a button new offer, then i select wich car it's about and select the motortype which sets the baseprice by choosing from a portal (that connects from table 1 to 2). The button sends the CarID to table 4 in list mode who then shows all available options on that specific car, then you can add a option with a button (which sets the quantity and OptionID of table 3 on 1) Its also possible to use a pulldown menu which sets the quantity seperatally.

The problem lies in the fact that i cant seem to get the OfferID from table 1 to table 3. All other data gives no problem... only the Offer ID

Table 1: pk: OfferteID foreignkey: BootID

Table 2: pk: BootID

Table 3: pk: RowID foreignkeys: OfferID, OptionID

Table 4: pk: OptionID

thanks!

[fishma]

Set all the IDs individually into individual global fields. Each selection sets the correct ID in to the correct global ID field. The information is then at your disposal.