Hi, I need some advice for creating a relationship between an excel spreadsheet and an access database. I would like this to consist of two main parts:
1. The Excel file should auto-fill certain fields based on an entered key (name or ID). I know how to do this with queries, but I suspect this might change based on the next requirement.
2. This is the hard part; I would like the excel file to behave like an infopath form does with access, where it not only fills in fields by queries to the DB, but can submit info to the database by key, as well as edit and resubmit information.
It doesn't seem like simply linking tables would work, because the excel form acts as a template for all of the entries in the DB.
Any advice would be greatly appreciated, thanks.