Multiple Master-Details forms problem

[Quoted] I have a couple of tables which contain up to 5 foreign keys - the keys are meaningless numeric sequences, the relevant tables have a meaningful descriptive column. So, I have M-D relationships where there are many Masters to each Detail.

I'd like to be able to do the following:

1. Create a form for creating this table, using the other tables for easy point and click. When I try this I get all sorts of problems with required values not being present as I move between the different masters.
2. Display the detail table as a multiple record tabular form with all the descriptive values rather than the keys in such a way as to allow easy updates. I don't see any easy way of displaying the descriptions along with the keys. Possibly a view which is kept in the same order as the detail table... yuck!

Any ideas or sources of inspiration?

Andy Received on Sat Jun 20 1998 - 15:35:13 CEST