how to design this form for data entry?

[siamandm]

Hi ,
in the attached db , i have add new table for the tent staus as below :

Capture.PNG

1- its recommended to be as separate table or i can mix it with table tblTent?
2- if its separete table how i design the from student to allow tent status?

Student-Address1.zip

regards

[Rudi]

If the Status table contains information about the status of the tent, I don't believe you need a separate table for that. A tent can only have 1 status (IMHO), so simply add the condition, type and wash service fields to the tent table and delete the Status table and Status ID foreign key.

[siamandm]

1- What you mean by IMHO?
2- i did modification as below :

Capture.PNG

[Rudi]

Sorry...that's an acronym.
IMHO is short for "In my honest opinion"

I said this as this is how I interpret your data and I believe it fits best in the Tent table as you have restructured it.

[siamandm]

Thanks a lot , you helped me always

[siamandm]

Sorry...that's an acronym.
IMHO is short for "In my honest opinion"

I said this as this is how I interpret your data and I believe it fits best in the Tent table as you have restructured it.

could you please show me how to add the other field of the tblTent to the form student... i did use subform, but it's not showing the corresponding files

regards

[HansV]

See the attached version. I created a query that displays data about the student and the tent, and used that as record source for the form.

Student-Address1.zip

[siamandm]

that's awesome, for an unspecified tent number can we make the condition, type .. . unspecified by default, or when the tent number changed to unspecified ... the things related to this tent chang to unspecified?

regards

[HansV]

You can use an update query to set those fields in tblTent.

[siamandm]

See the attached version. I created a query that displays data about the student and the tent and used that as the record source for the form.

Student-Address1.zip

Hi,
when I add a new student and make a selection of location I get this error below:

Capture.PNG

please help.

thanks

[HansV]

See if this version works better.

Student-Address1.zip

[siamandm]

can we make the Location combo box after update event: make the other combo box under it to be unspecified and the section combo box as well.

regards

[HansV]

You'd need to have an Unspecified Section and Unspecified Tent under each location.

Since you indicated that you wanted to use the TentNo field for other purposes too, it might be more convenient to drop the idea of using cascading combo boxes, and simply use text boxes for all the levels. It's not according to strict relational database theory, but the design becomes easier.

[siamandm]

in this case can we use the ZoneID to make the relation between the tblStudent and tbltent , as zone can be specified in all scenario?

regards

[HansV]

Yes, you could do that.

[siamandm]

thanks Hans