Haitham said:
Dear L4serK!LL,
It's realy better to send me ur db by zip file and i'll do it for u,,,
because i have no controld + form and subforms name.
Sorry,
Ready To Help At Any Time....
Saam
Sending the Database would be useless since you wouldn't understand the naming and all, but I'll try to give you a translated online version
Table
Options has field
ID (unique) and some text fields (not important)...
Table
Types has field
ID (unique) and again property field that don't matter here...
Table
Links holds pairs (
Type_ID,
Option_ID) (multiple Option_IDs for each Type_ID) (the pair is, combined, the primary key) which indicates the
possible options for that Type...
I have a table
Orders which has a unique key
ID again and has (next to some other fields) a field
Type_ID specifying the
ordered record from Types. Finally also a last table
Order_Details which stores pairs (
Order_ID,
Option_ID) specifying the
ordered options...
Now i got a form
Ordering linked to the Orders table. When one creates a new record, the moment the person fills in the Type_ID field (dropdown box) and that way chooses the type, I'd like to have all (Form_Order_ID,
Option_ID) pairs added to the Order_Details table, keeping in mind that the Dropdown_Type_ID specified in the dropdown box has a matching record in table Links: (Dropdown_Type_ID,
Option_ID)... So in fact when a new order is created I'd like to see all Options added as ordered by default...
BTW: sorry for taking me that long to reply
Have had other things on my mind lately...
Thanks in advance for the help