Search results

I broke the table into two tables and used FamilyNumber as the foreign key. I wish I could have a drop down list of the classes to see the grades of each.

Awesome, I got the form to work as two different subforms but I need to put functional buttons now that control the form as a whole piece like navigation controls.

Ok, I searched all over and it seems I have to build the classes form without so many tables.

Ok, I attempted to remake the grades form with the condensed tables but now it wont show up in form view or layout view :confused:. I did nothing to the relationships but move the boxes up and down to make them appear somewhat neat. I am taking a class on database concepts but its week 5 out of...

Thanks for the critiques and support, I felt like I was creating a monster and not something efficient. The form is per household which may have multiple children. I got rid of the subdatasheets and merged two tables. I tried to follow tutorials on how to do relationships for the grades and...

Also, is it possible to apply a filter on the entire form and subforms using the search button in the header?

Thanks for the greetings!

I am looking at the grading table and how did you allow for duplicates or set ChildID as a foreign key. The end result is what I need. Also, how would I properly create a search box for returning the ChildID for grade updates? I have attached the worked I have done. I would like to use the...

Sorry for the vague approach. I am going to try the suggestions. Thank you all for the help.

Hi everyone, I am making a database for a children's counseling group and have made a form for case entries or case updates. I am stuck on making a form and table that allows multiple entries(classes) per child(unique ID) wanted to know if this is possible since this part of a larger project...

Hi all, I am new to using ms access but I am taking a formal class on relational databases. I came here to ask a specific question and will attempt to post in the appropriate section. Any help at all would be great. Thank you.