I know a little so here goes my best attempt to explain:
When i start a new project in Access it allows me to use my SQL server data base - I am quite happy with that.
Question 1) Can I still use Access to develop my database with sql server and still use Access to create the Visual Basic front end?
Question 2) Linking tables together when creating a form. I have designed my tables and have built appropriate relationships between them. When I had to link tables together to get the combo boxes in access there was a simple "lookup" option which allowed you easily to select the table to look up from and therein the individual components. How is this achieved in Access with SQL?
Many kind thanks in advance.