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!

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.