master form - sub form question

[czarjosh]

I have a sub form on my main form. the main form registers a person, and the sub form registers that persons guest. It dumps both people into a Registration table, however the long integer field in this table that records the guest (identified by RecNumber) is not recording what I like.

The Guest of the main Person gets the RecNumber value of that person in the guest field. THIS IS NOT WHAT I WANT. I want the RecNumber of the Guest to be stored in the Guest Field of the main registrant.

How do I resolve this?

 

[KenReay]

Hi

Your design implies that each 'Main Person' can have only one guest. I would have expected the design to be that the Guest Record had a column for "HostId", which would be the Id of the "Main Person" record, in that way a host could have 'n' guests

Could we just clarify if this is what you are trying to do before looking at a solution?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[czarjosh]

In the relationship viewI do have a 1-to-many between this table and itself. SO Table Registration has a 1-to-many relation with Registration_1, so theoretically we do not need a one to one relationship.

 

[KenReay]

HI

You say

"I want the RecNumber of the Guest to be stored in the Guest Field of the main registrant"

this means that one Registrant can have only one guest, but a given guest can have many Registrants

I repeat is that what you intend?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK