A form with a subform can't be continuous forms..what's another setup?

[Nate1749]

I've got what seems to be a difficult setup and I can't seem to find a workaround for the form part.

There are multiple loan periods, each loan period has items that will only be one general number or date, and will also have information that will occur multiple times.

So the setup is I have a table with fields like LoanPeriod, EFA... and then I have a one-many with the table that has more detail about that loan period such as CertDate, DisbDate, etc.

In form view I have a form that has the general loan period, then a subform with the detail.... This setup works great, except it can only do ONE loan period... Since there are mutiple loan periods which each have general information and detail I think a continuous form would work best, except it can't be done.

I've kind of hit a mental block and can't think of a workaround. This setup works great in table view, I just can't think of how to have it designed on the forms....

-Nate

 

[willir]

Nate1749

A subform does not have to be contineous. Consider a "Single Form" instead of continuous. You will need the navigation buttons enabled so the user can scroll through the child records. Not all the information is displayed on the continous for, but it works.

An alternative solution is to include the barer minimum in the continuous subform with a small command button. The command button opens the specific detail child record.

If you want to get fancy, you could use both. The user selects the desired record from the continuous subform. This sets the reference for an ajacent single subform that depicts the full record for the item selected in the continuous form.

Does this spark any ideas??

Richard

 

[danvlas]

Try the One-To-Many-To-Many setup (The Northwind or Solutions sample database show you how to do it...):

Create one main form (Main) with no recordsource.
Place your current main form as a subform on Main.
Get the primary key from the subform and display it on Main in a textbox (KeyField)
Place your current subform on Main
LinkMasterFields: KeyField
The second subform will follow the current record on the first subform and they will be both continuous.

I think that's the best you can do...

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html