Open form linked

[jax]

I have searched the forum but seem to be missing something.
I have a client table and several grant tables for different grants that each client can apply for. The tables are linked one to many.

What i have is a Clients main form showing Refnum, Name, Address etc. What I want to do is have command buttons on the Clients main form to open a specific Grant application form linked to the clients main form. There are currently 4 different grants they can apply for and they can apply more than once.

I have used the command button wizard to link each Grant form with the Client form, but when the Grant form opens it doesnt show the Refnum or the Client name etc. The Graqnt form is based on a query made up of the Client table and the Grant table.

I have looked at the wherecondition, openargs but i cant get it to work, mostly because i dont understand the code. I also need to see any previous applications that have been made for that grant.

Not sure I am making sense - sorry.

Can anyone help?

 

[KenHigg]

Jax, I think I would try to set this up with a form / subform. Q: How diffierent is the grant data you need to store from one grant type to the next? You may be best to store all your grant data in one table...

 

[jax]

Hi Ken, Thanks for replying. I have looked at making each grant application a subform but it will make the Client form very untidy.

In answer to your question - each grant application requires very different information - so its not really possible to have one table for all the grants.

 

[KenHigg]

Could you put each subform and a tab in a tab control?

 

[jax]

I have never liked using tabs but this might be a time when they will be the best solution. I will give it a try and let you know how i get on. Thanks again

 

[KenHigg]

The downside is that you can take a performance hit as your tables grow with all the relationships having to be maintained. How large do you anticipate your main table and subordinate tables getting before you archive?

 

[jax]

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will recieve as this is a new project, but probably approx 250 for each table to begin with.

 

[jax]

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will recieve as this is a new project, but probably approx 250 for each table to begin with.

 

[jax]

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will recieve as this is a new project, but probably approx 250 for each table to begin with.