Adjusting Layout based on input needs per record
I searched online and here in the forums with no luck; maybe my search terms weren't the best, I don't know, but here's what I am trying to do:
I need to track receipts and calculate data from all records from what is entered per receipt. Here are the fields (I think) I need:
Item 1 etc.. (for each item purchased)
-- qty of that item
-- cost of that item
-- number of items for sale within that item (say is is a package of muffins: how many muffins for individual resell within that pkg.)
Total Cost (after tax)
Type of item (consumable or resellable)
Each receipt will have a varying number of items purchased -- generally from a few to somewhere less than 20.
I'd prefer the database to be as visually clean as possible, only showing what is needed per reciept. That is I don't want twenty Item fields (with the corresponding sub-data -- qty/cost/number) showing unless there are twenty purchased items on that particular receipt. Say I purchased 3 items on a given receipt, I only want to see three Item fields (with sub data) on the record.
If that is not possible and I have to have static fields for each possible item, I don't want to see Item's sub data unless there is something entered into the field for a given Item.
Hope that makes sense...
The question: Is there a way to dynamically add Item fields to a record as needed and when that Item field is added to the layout, also show the sub data for that item?
Thanks in advance.