I have an application where the Access database has several tables that are linked with enforced referential integrity. Is it possible to collect information on a single screen which would be dispersed to these several tables (including the master table) and to have it stored/appended using a "Store" pushbotton on the input form?

Any suggestions would be gratefully received.