By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Acess tables

P: 13
Sir!
i have Created 3 table for which i had given internal relationships for which i want to feed the values through a Form.

is it possible entering the values through form and getting the information through form.....

and after inserting certain values supppose upto 40 records.... then i want then to display in a proper manner with some select feilds of the table of 3 .....
Sep 5 '07 #1
Share this Question
Share on Google+
1 Reply


P: 47
Create a query, adding the 3 tables concerned. Select the fields you want on the form annd save the query.
Open the forms tab, select New, select Autoform: Tabular, Columnar or Datasheet, depending on which type you want. Select your query as source and save the form

If you want to update from the form make sure you have selected "Enforce Relationship Integrity" AND "Cascade Update Related Fields" when creating your relationships.
Sep 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.