main & sub form

[JustinD]

hi,


I am working on a required template for my company, the main form holds few information and the sub form have different details. both have different entry's.
for a single entry in the main form details, it should also store multiple entrys of subform details.
the table has been created but when try to add new records, the sub form does not go blank but still show the previous information.
here is the screen shoot of the form.

request all your help.

[RuralGuy]

How have you set the LinkChild/MasterFields properties of the SubFormControl?

[JustinD]

Sorry i am not too good in access...
with the youtube tutorials i created the below two tables -> using the from wizard i created the form...
please guide me where i went wrong
Main Table
ID
Customer_name
Ourdc_no
Challanno_date
material

Sub Table
s_no
operation
furnace_media
temp
time
hardness
regd
msrd
remarks

[RuralGuy]

Have you place the Main Table ID (hopefully an AutoNumber) in the Sub Table as a Foreign key (FK)?

[JustinD]

ID is auto number primary key... which one has to set as Foreign key?

[RuralGuy]

That same value needs to be in the 2nd table as a FK. Then Access can create the relationship for you. It is also the fields you will use in the LinkMaster/ChildFields properties of the SubFormControl.

[RuralGuy]

It is generally a good idea to name the PK field something significant so you can tell by the name where it came from. In your example it would be something like: MainPK. In the 2nd table the FK could then be name MainPK and you would know what it contains. The FK field needs to be a Long Integer if you had not already figured that out.

[ssanfu]

Ummmmm....
In the "Main table" (the one side), I might use something like "MainPK"
In the other table (the many side), I might use "MainFK"...... so there wouldn't be two fields with a "PK" designation.

But that is just the way I would name fields.......