Foreign Key in a form

[duffy180788]

Hi all,

I basically have an Issue's table and a Customer Table relationship set-up.


I want to information to be viewed in the Customer table however I can only see 1 Issue where as a Customer may have 2 or 3 Issues.

I have come up with inserting the whole table into the form however I don't like this look , is their another way of doing this?


Thanks

Craig

 

[billmeye]

I'm guessing the Customer table is the record source for the main form and Issues for the subform. Do you have the two forms linked by the Customer table primary key?

 

[duffy180788]

Hi yes that's correct sorry for not expressing it clear enough,


Form is ( Edit Customer )

The sub form from the issues form was created automatically when I dragged the table in the form, how ever this this does work for me, as I can see more than 1 issue (if more than one exists) how ever I don't like the look and was hoping for a field look , to go with the rest of the form.


thanks

 

[duffy180788]

I think I have found a method, if I right click on the table, and choose Sub-form it gives me an option of datasheet, or Form... The form look is what I like and would like to stick with however is their a way to keep it as form look as default?

 

[billmeye]

If you click in the subform it will show the property sheet for the subform, there you can change your default view and save the design.

 

[duffy180788]

thanks billmeya


cheers.