Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple selection query
dear all I have a web based form and a few (5) fields on it, from which a user can select the options (or do a text input) and perform a query. I have problem in forming a query depending on user's selection i.e. user can select a criteria from the drop down list or can select leave it blank...- medisa
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
multiple tables INSERT
thanks Terry I think that my problem is due to me having one to many relationships between tables ... hence the primary key in one table is the foreign key in another - due to this I have problems with INSERT .... for example, after inserting data in one table I then have to copy the primary key...- medisa
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
multiple tables INSERT
dear all can anyone help me with the following: syntax for INSERT statement into multiple tables i.e. I am trying to insert rows(using Java and SQL with Access) into more then one table with one button click; e.g. user fills in the form and clicks submit button - data from the form's fileds...- medisa
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
