I have a set structure as follows:-
Quotes-Summary (Parent)
Manufacturer (child 1-many link)
Returns (child of Manufacturer 1-many link)
Table 'Manufacturer' has a field called 'Unit-Manu' which via a browse allows the user to enter numerous suppliers for one invoice to make up the total (ie parts come from different suppliers to do job)('unit-value' and ('unit-manu-invno' also used to do this).
The 'returns' table has to look at the 'manufacturer' table and allow the user to select (via drop down list box if possible) any of the suppliers entered for that invoice only (if none then list shows none and return not possible)
and then it fills in the 'rtn-manu'+'inv-no' fields in the 'returns' table.
This may be done for just one supplier for that invoice or 2+ different suppliers for same invoice or indeed multiple times for a supplier/s.
(if more than 1 item is returned to supplier vs his invoice no etc).
This info required does not adjust anything in the manufacturer table just restricting what choices user has (ie only existing for that invoice).
This sounds a very simple task but I have been pulling my hair out trying to work out the best way to do it and how.
Please please can you make a guy happy and explain (with example script if required) how to do this.
Many thanks for your assistance.
Regards
Mike Lyon
Quotes-Summary (Parent)
Manufacturer (child 1-many link)
Returns (child of Manufacturer 1-many link)
Table 'Manufacturer' has a field called 'Unit-Manu' which via a browse allows the user to enter numerous suppliers for one invoice to make up the total (ie parts come from different suppliers to do job)('unit-value' and ('unit-manu-invno' also used to do this).
The 'returns' table has to look at the 'manufacturer' table and allow the user to select (via drop down list box if possible) any of the suppliers entered for that invoice only (if none then list shows none and return not possible)
and then it fills in the 'rtn-manu'+'inv-no' fields in the 'returns' table.
This may be done for just one supplier for that invoice or 2+ different suppliers for same invoice or indeed multiple times for a supplier/s.
(if more than 1 item is returned to supplier vs his invoice no etc).
This info required does not adjust anything in the manufacturer table just restricting what choices user has (ie only existing for that invoice).
This sounds a very simple task but I have been pulling my hair out trying to work out the best way to do it and how.
Please please can you make a guy happy and explain (with example script if required) how to do this.
Many thanks for your assistance.
Regards
Mike Lyon
Comment