Recent content by kyserkess

fantastic! So, I will set up these tables and add a screenshot here. Is it difficult to setup the combo box? I can try to use the wizard to do that and see how it goes. You are very helpful!

hi Jz, I was trying to figure out how to make foreign keys, but I wasn't able to. So, if I make them into multiple tables, will there still be parent tables that effect child tables? So, if I select something like Kung Fu, then my Substyles narrow down to Shaolin, Wing Chun, Choy Fat, Hung Ga...

one more so i can post an image

I guess I can post twice more?

This forum will not let me post an image here until after I have posted 9 times. What else can I do?

Bob, my database relationship diagram screenshot is at the URL I posted earlier: cbsanswer.com/martial_arts.html It seems like the parent table and the most logical thing to do. You can ignore the Venue and Seminar Registration table, they are not used in this form.

OK, it didn't go so well. I created a form in the Wizard, but it did not give me the option to create subforms. If I selected either of the other two tables, it allowed me to create subforms, but I wanted the form with the most records to be the main form. Of course, when I update a record now...

Thanks so much Bob, i will try it and tell you how it goes.

Is there a way to make the subforms input boxes like the main form instead of mini tables? And can I select existing rows within a 3-part-form like this? For instance, say I am entering a new Martial Art Instructor's information, but his Martial Art Style is already in my MAStyles table, can I...

Aw crap, sorry I mistyped the address: it is cbsanswer.com/martial_arts.html I tried to attach the database file, but I received the message that it exceeds the uploading limit, even though it is practicably an empty database. Yes, Bob, it is a regular Access form.

Thank you for the welcome. I hope I can find some help here. I spent alot of time taking screen shots and building a webpage to show all of my tables, forms, and relationships to save from all of the confusion of explaining and understanding what I am trying to do. It is certainly not going to...

I am pretty sure this is the whole reason for databases and forms right? Goal: Be able to add new records into multiple tables and/or select existing records (mix-match) so I can update the database easily and preform spesific quarries later. Problem: When I add information to a page in...