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.

Best regards,
sabertec2

Is that you are looking for a working example that pertains to your requirement? I don't see that is possible here. May be you can try that out at your end and post here explain where are stuck up with and post relevant code too. That way it should help you out.

Cheers!

_________________________
- Vijay G
Strive for Perfection