sub form (1 Viewer)

foxtet

Registered User.
Local time
Today, 17:13
Joined
May 21, 2011
Messages
129
Dear friends,
I want when save button is clicked the sub form below gets populate the added record.
If any ideas please share.

foxtet
 

Attachments

  • subfrm.zip
    732.7 KB · Views: 80

foxtet

Registered User.
Local time
Today, 17:13
Joined
May 21, 2011
Messages
129
Can any one here get me a solution for this thread.

foxtet
 

JHB

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
Put in an event there save the record and afterwards requery the form.
 

foxtet

Registered User.
Local time
Today, 17:13
Joined
May 21, 2011
Messages
129
not going well,
could you worked out the attached file for a solution?

foxtet
 

JHB

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
Try the attached database, I've imported all into a new database, because what you attached had some problem.
 

Attachments

  • SubFrmKopi.accdb
    764 KB · Views: 44

foxtet

Registered User.
Local time
Today, 17:13
Joined
May 21, 2011
Messages
129
It is really helpful.
Thank you for convenient solution.

foxtet
 

Alvarogue

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
Yes I have! :)
What problem do you've?
Do you have a sample database, then post it with some sample data, (zip it)?
 

Alvarogue

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
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

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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?
 

Attachments

  • 4GlobalDispatchDatabase.zip
    390.5 KB · Views: 62

Alvarogue

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
Could you show some data sample and relationship for the tables CompanyT, TruckT and DriverT.
 

Alvarogue

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

Have been here a while
Local time
Today, 14:13
Joined
Jun 17, 2012
Messages
7,732
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

Registered User.
Local time
Today, 06:13
Joined
Jan 3, 2016
Messages
40
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

AWF VIP
Local time
Today, 13:13
Joined
Jul 26, 2013
Messages
10,354
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.
 

Users who are viewing this thread

Top Bottom