make-Tabel Query automtic update ?

[118600]

Hi,

I have created an Invoice Form ( looking for a report of a record which will be selected ) from a select query. In this query three tables have been used.

PackageDetails ( PackageNumber, Description, ReferenceNumber, DueDate )
OrderDetails ( PackageNumber, OrderNumber, OrderDate)
CompanyDetails ( PackageNumber, CompanyName, CompanyID, Address, ZipCode, City, TelefonNumber)

PackageDetails is a linked table which is updating everyday. OrderDetails and CompanyDetails are my own created tables ( empty ) related with PackageDetails.

I have to create an Invoice Report and Also I have to save the report information (entered) for future references.

My Problem:

My invoice Form can not be modified. Because it is created from a query. It is showing me just Details which is present in PackageDetails.

Suggestion: should I make here a table by using make-table query with combine fields ? In this case I can modify my new table according to PackageNumber. But In this case I cant get automatic update in my new table.

If anyone have an idea ?

I hope that I have stated my problem briefly, also I can provide more details if you need.

Thanks a lot in advance.

 

[PHV]

Provided the RelationShips are properly set you may consider a main form based on PackageDetails and linked subforms.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[118600]

Thanks for your reply PHV.

So i should not use make-table query, simply the select query ? but in this case i cannt modify/update. How i can add extra details in my selected tables through this form ? The two tables are linked with PackageDetails.

Cheers