Hi all,
I have a sql server database that several websites use. Now the customer wants this to be linked to an Access2007 program. Ive created a datasource file etc and have the tables linked to the database just fine. What I need is for the relationships between the tables to be able to create dropdown lookups so that when a user wants to add a new row instead of having to type the id in they can select it from a list.
Ive created the relationships between the data in Access but because they are sql linked tables and not Access2007 tables I dont seem to be able to do it and I can copy the data into an Access2007 table as when the data is changed it doesnt update the sql server.
Any idea of how to do this? I'm very close to giving up and creating a nice WPF app for them to do it with instead!