Multiple tables to create one Form??

[Gravity101]

Hi everyone, i'm really new to MS.Access and really need your help, i've been trying to fix the problem but it seems it don't works.

So, i have 3 tables which are:
-Header
-Rate
-Detail

Header consisted of:
-ServiceNo
-SupplierName
-SupplierCountry
-SupplierAddress

Rate
-ServiceNo
-Tax1Rate
-Tax2Rate
-Tax3Rate
-CodeNumber

Detail
-ServiceNo
-CodeNumber
-GoodsDetail
-Merk


-Netto

and using the Relationship One to many from -SeviceNo in Header to ServiceNo in the Rate and Detail.

so i'd like to make a form that consists of:
-ServiceNo
-SupplierName
-SupplierCountry
-SupplierAddress
-Tax1Rate
-Tax2Rate
-Tax3Rate
-GoodsDetail
-Merk
-Netto

when i using form wizard to make this, and try to add the datas, it's said that the form is non-updateable.


is there actually a way to make a form from multiple tables?
Thanks in advance.

[Bob Fitz]

Hi

Can you give us a little info on what you are tring to do with this DB and what each of the tables is holding data about?

[caddcop]

You can make a main form that uses one table as its data source - this should be the table with 1 record for many of the other table records.
On this form, you will create two subforms. Subforms are areas within another form that display secondary forms. The subforms will each use one of the other tables as their data source.
When you scroll to a record on the main form, each subform will display one of the matching records of the other tables - if there is a matching record. Within each subform, you can scroll among the matching records.
If you edit data on any of the forms, you cannot scroll within any of the other forms until you save the data - actually, by default, access will automatically save the data if you try to scroll. It will also save the data if you enter one of the other forms fields. Basically, if you move focus into one of the other forms while the current form has unsaved edits, access will have to save those edits before allowing focus to shift to another form..