Forms are very rudimentary Ron, and as soon as you start getting complex I think they lose much of their usefulness.
One thing (similalrly, just thinking out loud) you could try. Consider a Customer table, a Customer Sales and a Products table. You would use Forms to maintain the Customer and Product tables, simple id and details. For the Customer Sales, you would inject a DV of customer names, and a VLOOKUP to get the ID, and similarly for the Produccts. The Sales data would be a Form, or maybe just event driven input.
Does that make some sense?
is to have