Hi
We have a database with multiple tables. Each needs to hold a piece of information. The database keeps track of user info, computer info, network data jack and network switch. All the tables are link by using a similar value that exist on all tables, and bringing together by using a query. Then, it is presented all the important fields to a single form. I can see the information but cannot be edited, or add new records.
By the way, the database resides in an MS SQL Server. The program use to connect to is Microsoft Access 2013. After doing some readings, some people have recommended to link the tables. Well, I have them link using a query.
Do I link them in MS SQL or MS Access 2013?
What are your suggestions?
Thanks
We have a database with multiple tables. Each needs to hold a piece of information. The database keeps track of user info, computer info, network data jack and network switch. All the tables are link by using a similar value that exist on all tables, and bringing together by using a query. Then, it is presented all the important fields to a single form. I can see the information but cannot be edited, or add new records.
By the way, the database resides in an MS SQL Server. The program use to connect to is Microsoft Access 2013. After doing some readings, some people have recommended to link the tables. Well, I have them link using a query.
Do I link them in MS SQL or MS Access 2013?
What are your suggestions?
Thanks