Retrieve Previous Record: DLookUp

[jzwp22]

Do you know they were in a seperate table called tblData and I ditched it as it seemed to represent a one to one relationship with tblRespite and Ive had problems with DLookup previously in 1 to 1 relations, hence the reason I ditched it

I'm not sure to what they your are referring, the questions or 5 yes/no fields in the user table.

In any event you actually have a many-to-many relationship between the questions and respite event (or user) since a question can apply to many respite events and a respite event can have many questions.

The same probably can be said for the 5 yes/no questions in the user table.

 

[rodmc]

I'm not sure to what they your are referring, the questions or 5 yes/no fields in the user table.

In any event you actually have a many-to-many relationship between the questions and respite event (or user) since a question can apply to many respite events and a respite event can have many questions.

The same probably can be said for the 5 yes/no questions in the user table.

My thinking was a user can have many respite events and a respite event can only have one user.

anyway I'll take on board what you said and see if I can rejig without too much work

 

[jzwp22]

My thinking was a user can have many respite events and a respite event can only have one user.

That is true but you have the other parts of your database too that have relationships that must be taken care of properly.

 

[rodmc]

cheers all the same, better that I fix that now rather than wait until its in use

 

[jzwp22]

If you encounter any questions as you restructure the database please do not hesitate to post back.