data not generating in child table.

[Tommo]

So I am trying to set up a DB for a dance school.



I have created a table for charges. In this table is my StudentID and ClassID (the keys from my main tables)

I have done a lookup from the classID for the term cost which is a field in the Classes Table.

It just gives me a dropdown which i can select from the list..

FYI; I have enforced integrity and the field is lookingup the Class ID & term cost with the classID width to 0.

Let me know if this makes no sense.

Ta

[ranman256]

did you make a subForm?
make a form with the subtable.

in the master form, assign the form to the subform box
set subform.sourceobject = frmCharges-sub
set LINK MASTER FIELDS = StudentID
set LINK CHILD FIELDS = StudentID

[June7]

Sounds good. If you want to provide db for analysis, follow instructions at bottom of my post.

[Tommo]

Right here it is.

iD Studios Finchley RegisterSTUDENTS REMOVED.zip

I have had a good fight with it. What am I doing wrong guys.

[June7]

Looking at Relationships window. Not seeing need for tblCharges. tblClasses has the TermCost. Build query that links tblEnrollments with tblClasses to retrieve the cost for that class enrollment.

Showing a second instance of tblClasses that is linked to tblCharges on TermCost field. That makes no sense.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Better field names would be: TeacherID_FK, EmailAddress, IsFreeClass.

[Tommo]

Ok cool.

Thanks for all of this.

I Have some work to do.

[Tommo]

I have another question if possible.

I am trying to think it through so my payments work well.

At the moment if i add a payment the Class ID is just a dropdown and it does not restrict me to the classes that student is in.

Cheers

[June7]

That is known as cascading or dependent combobox. Review: http://datapigtechnologies.com/flash...combobox2.html

In your case the combobox RowSource will have to reference tblEnrollments, maybe even include tblClasses in the SQL statement if you need additional info about the class.

Where are you entering payments?

[Tommo]

I am talking about within the table.

It is going to be within a form within the student data entry area. I haven't quite worked it out yet.

I do appreciate I am in over my head lol.

I think once the Payments is in a subform I can control the combobox like you said. Correct??

[June7]

Right, dependent comboboxes can only be on form, can't do that in table. Lots of threads discussing this topic. Here is a recent one https://www.accessforums.net/forms/t...box-54959.html

[orange]

I would recommend against the use of Lookups at the table field level.
Is this related? https://www.accessforums.net/access/...ses-54952.html