sub form

[foxtet]

Dear friends,
I want when save button is clicked the sub form below gets populate the added record.
If any ideas please share.

foxtet

 

[foxtet]

Can any one here get me a solution for this thread.

foxtet

 

[JHB]

Put in an event there save the record and afterwards requery the form.

 

[Alvarogue]

just like that??

 

[foxtet]

not going well,
could you worked out the attached file for a solution?

foxtet

 

[JHB]

Try the attached database, I've imported all into a new database, because what you attached had some problem.

 

[foxtet]

It is really helpful.
Thank you for convenient solution.

foxtet

 

[Alvarogue]

Try the attached database, I've imported all into a new database, because what you attached had some problem.

Hey JHB, are you knowledgeable in Relationships and subforms?? I have major problems with my database and I need some extra help to fix them up. I been researching without success.

 

[JHB]

Yes I have!
What problem do you've?
Do you have a sample database, then post it with some sample data, (zip it)?

 

[JHB]

It is really helpful.
Thank you for convenient solution.

foxtet

You're welcome, good luck.

 

[Alvarogue]

Yes I have!
What problem do you've?
Do you have a sample database, then post it with some sample data, (zip it)?

Yeah, here:
http://www.megafileupload.com/inxN/4...chDatabase.rar

The problem I have is that my Navigation Form is working directly from a query, instead of the tables, and I did that because if I did that directly from the tables, the 3 search boxes that I have do not work propertly...
Also I have a problem with the relationships, because when I try to arrange One to Many ( in this case, Many trucks, for 1 company ) Every time I try to add a new truck gives me an error:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redifine the index to permit duplicate entries and try again."

For some reason I am not able to fix this two large problems I have, and since I am so limited in knowledge yet, I am not able to fix this situation...

Thank's for taking your time tho.

I really appreciate it.

 

[Alvarogue]

Yes I have!
What problem do you've?
Do you have a sample database, then post it with some sample data, (zip it)?

BTW, The trucks are located in a different form, so its a Form, from another Subform.

 

[JHB]

Could you post your database here in the forum, because I can't open file with the rar extension.
Do a "Compact & Repair" and then zit it.

 

[Alvarogue]

Ok here it is. I hope this can work. Please let me know if you need more info, but as soon as you play with it, since is a small database you get it checked out in a couple of minutes ok?

 

[Alvarogue]

Could you post your database here in the forum, because I can't open file with the rar extension.
Do a "Compact & Repair" and then zit it.

Please check the last post

 

[JHB]

Could you show some data sample and relationship for the tables CompanyT, TruckT and DriverT.

 

[Alvarogue]

Well CompanyT Should be the mother and TruckT and DriverT should be the childs. This is a One to Many Relationships that I want to build. The thing is that every time I add More then 1 truck x company using the subform in the Truck Tab in NavigationF, gives me an error.

 

[JHB]

Yes it is wrong setup I know that!
But what is CompanyT, data for a truck company or what?
What is the relation between CustomT and CompanyT?
I don't know your business, so you need to explain it, else I can't help you!

 

[Alvarogue]

Yes it is wrong setup I know that!
But what is CompanyT, data for a truck company or what?
What is the relation between CustomT and CompanyT?
I don't know your business, so you need to explain it, else I can't help you!

Table Relationship is:

*CompanyT One to One CustomerT
*CompanyT One to Many TruckT
*CompanyT One to Many DriverT
*TruckT One to One DriverT

 

[Minty]

Okay - Your problem appears to be that you haven't actually got a table where all this information is pulled into - a transaction or any form of joining table.

You haven't defined what you are trying to actually achieve.

We know what you are trying to do with the table relationships, but you haven't actually told us what the purpose of the database is - In plain simple English.