Check box for one record, form pulls from multiple tables

C

chellebell1689

Registered User.

Local time

Today, 13:33

Joined

Mar 23, 2015

Messages

267

• Jun 1, 2015

• #21

Finally got it to work! (Had to delete over half the members and a ton of the fields, but all the required info is there.) Thank you so much for your help!

**Update:
I'm going home for the day, so if I don't reply right away, that's why. Thanks again for all your help and for taking a look at this!**

 

Attachments

• NHBC database.zip

  131.7 KB · Views: 94

Last edited: Jun 1, 2015

V

vbaInet

AWF VIP

Local time

Today, 21:33

Joined

Jan 22, 2010

Messages

26,374

• Jun 3, 2015

• #22

Ok, got it. The problem is the same as what I mentioned back in post #4, but besides that, you have a bigger problem and that is to do with your table structure.

My advice is that you post a new thread in the Tables forum explaining your table structure and what the db is about, and someone will be able to properly restructure it for you. If you solve the structural problem, you automatically solve this problem too.

 

C

chellebell1689

Registered User.

Local time

Today, 13:33

Joined

Mar 23, 2015

Messages

267

• Jun 9, 2015

• #23

Thank you! This database is my practice db, I've got one that I'm slowly adding things to (only once I learn the proper way to implement them). The new one, I believe, is structured better. I started that one after someone shared a tutorial on Entity Relationships Structures (I think that's what it was called...). Anyways I understand what the solution is now. Thank you so much for your help!!

 

V

vbaInet

AWF VIP

Local time

Today, 21:33

Joined

Jan 22, 2010

Messages

26,374

• Jun 9, 2015

• #24

If you need us to have a look at your tables once you're done implementing, let us know... in a new thread and in the Tables section of course

Good luck with the learning process!