Sending field data in queries to tables problem

[faizulhu]

I have a database containing 3 tables: Book, Member, and Loan. A relationship exists between the 3 tables(the relationship has no problems, I have enabled referential integrity). I created a query named Loan Query which uses all the 3 tables.

In the loan Query, the Member ID field is in Loan Table and the Member Name field is in the Member Table. This allows the database to automatically type the Name when the Member ID is entered into the query retrieving the information from the Member Table. This also works fine. But the problem is that the Name field of the Loan TABLE (not query) remains blank. So i have to keep the required property of that field to no.

All I want to do is for the database to also write the Name in the Loan Table along with the Loan Query. I will also have to apply the same for other fields also.

I am a beginner in Microsoft Access and so whosoever replies, please elaborate the solution.

 

[apr pillai]

sending field data in queries

Queries are not meant for data entry purposes, Forms are. Design a Form on Member Table. Actualy you don't need to duplicate the Name Field in Loan Table, you can get the information for reporting purposes by linking it with the Member Table on ID. But if you prefer to add it to the Loan Table also then design another form on Loan Table also. Now Open the Member Table Form in Design View position the Form slightly away from the Database window so that you can see the Loan Table Form. Click and Drag the form and drop it on the detail section of the Member Form and position it properly on the Main Form. Click on the sub-form (loan form) and display the Property sheet. You will find the LinkChild Field and LinkMaster Field Properties. The ID Fields of both forms you will find on these property area because you have already set relationships on the tables earlier. Now enter a coma after ID and enter the Name field Names on Both the properties, say ID, MemberName.

Now, when you make an entry in a new record on the Loan form other than these two fields you will find these two fields are automatically filled in with ID and MemberName from the Current Record of the Main Member Form.