Table/Linked Table with Specific number of rows

[vik808]

Hi,



This maybe a starnge situation but I have an Ordering form where I have to show X number of options
for each order. So if I have to display all the options to the user (say 30 types of products).
Would I have to prefill a LineItem table with each option type?

See below.
Thx!!



for ea

[June7]

If you use a bound form then yes, would have to create the records and open or refresh form to that set of records for user to complete entries for quantity. In which case, the combobox is of no use. You would not want user to changed the item. Make it a Locked textbox.

[vik808]

This would really bloat the LineItem table with blank rows wouldn't it?

[June7]

Yes, if quantity is not required for each item then would need code to remove those 'blanks'. This could possible be a DELETE sql action triggered when the form closes.