Hi All,
I'm having real trouble trying to add an existing record to my subform instead of creating a 'new' record. My scenario is:
I have a branches table and form where my users can create a customer or branch - ie: KFC Auckland (Branch) or KFC Wellington (Branch) etc
I also have a Head Party table which is a one to many relationship to my branches. I can create a new head party and then go into my branches form select each KFC record one at a time and add it's head party - ie: KFC Head Office.
What I would like to be able to do is have the ability to create multiple branches, then when the user gets the head party info, open the head party form, create a head party and type the ID of each branch associated with the head party in a subform, thus linking them together.
I hope this all makes sense!
james
P.s
i only chose KFC as my example as I thought it was recognised worldwide!!