Post/Get from 2 Tables in Relational Database
Have two tables in an Access database. One table is the Client Info, the other is the Sales info. The two tables are joined, where the Client info is connected to one field of the Sales info.
I've been trying to accomplish two things:
1. Create a form that will post information to both tables.
2. Create a form that retrieves information from both tables.
I've made several unsuccessful attempts at both.
I'm sure this is a common procedure, but am new to working with ASP and database.
Any help is appreciated.