kbrooks
Still learning
- Local time
- Today, 17:39
- Joined
- May 15, 2001
- Messages
- 202
I've only used a subform once and my brain has gone absolutely blank today so please forgive me for the following stupid question(s). I haven't set up the database yet, I'm still drawing it out on paper to see how best to set it up.
For every record we will need an Account#, Name, and Type. They Type will drive what other information we will need. For instance, if they choose "Charge", I need them to enter Action, Date, Charge Code, etc. If they choose "Payment" I need them to enter Action, Date, TCode, etc.
I'm not sure if I should make these subforms, or lump them all on one form and make them Visible or not based on the selection from the combo box.
And here's my big time stupid question. If I set up one table (Patient) with ID, Account#, Name, Type....and then set up a separate table (Charges) for Action, Date, ChargeCode, etc.....do I need to have the Account# field on the 2nd table so it will know which record goes with which? Or does the ID# alone do that??
For every record we will need an Account#, Name, and Type. They Type will drive what other information we will need. For instance, if they choose "Charge", I need them to enter Action, Date, Charge Code, etc. If they choose "Payment" I need them to enter Action, Date, TCode, etc.
I'm not sure if I should make these subforms, or lump them all on one form and make them Visible or not based on the selection from the combo box.
And here's my big time stupid question. If I set up one table (Patient) with ID, Account#, Name, Type....and then set up a separate table (Charges) for Action, Date, ChargeCode, etc.....do I need to have the Account# field on the 2nd table so it will know which record goes with which? Or does the ID# alone do that??
