Search results

Okay, here are my changes. Thank you Pat for looking.

OMG, I got it working. I had selected the linking fields in the wrong order. Sorry

Ok, I have been working on this. The issue I am having is getting the data I want. I have created all the forms and am linking the master and child fields. The primary key is an auto-generated number which means nothing to the user. The catalog ID number is what they use i.e., QTC-101. If I...

Okay Let me work on this. Again thanks for the guidance.

Thank you that worked

I changed the forms to continuous forms, which is better than single form. I do not know how to get the course ID to auto-populate on new entry. I can manually enter it but I need it to auto populate.

Ok I am able to from the course list form go to the lesson list and the lesson form connects to the corrects to the correct lesson and course. The issue I face is on the lesson form I have an add lesson button, when I click that button it drops the course ID. So when I add a new lesson it is not...

Oh my, I am not sure my skill set is there yet. I need to draw this out so I can see it in my mind and then I have to work on how to make it work. I initially tried something like this but I had a hard time getting the buttons to make the correct connection. For example, if I was on course 1...

I do not have a Course ID in every Table. All the items in the subforms link back to the course. it goes something like this... There is one course, the course may have many lessons, Lessons may have many topics, topics may have many events, and events have many review cycles. I bound the...

I could actually attach the db.

OH, Those topics have not been in any of the courses I have bought. I now have my next research topic. Thank you. Sometimes I feel I am taking one step forward... LOL

Sorry I think I replied to the wrong Post. Here are my table relationships.

Is this what you are asking for? Here are the relationships I have so far.

I should also add that I have removed calculated fields from my tables. If I understand correctly, I should place those on forms and reports. There is no need to store that data in a table.

So here I am with another table Question. I removed all the Look-up fields from my table. I had one field that was a multi-value field (roles). A client may be assigned multiple roles. I now understand that is bad, bad, bad. I am creating my form and need to assign the roles to the client. Is a...

Thank you for the link. I have saved it for future reference.

I just found this out. I was trying to put some calculations in my report and found that the look-ups I had in the table were giving me fits. i have moved all the look-up fields I need to the form. I just spent 2 hours adjusting the table. It is hard for me to wrap my mind around the table view...

I have taken three online courses, each instructor has done things differently, without any clear explanation. I was wondering if you guys might help provide clarity. When setting up the tables why do you not use the lookup wizard for a field so that it will populate with the value as opposed...

That all makes sense. I now understand what you are saying. I will not clear the field.

#7 did not work either. It did not clear the field. Thanks tho