Search results

I was not looking to improve any standard. I was trying to make something easy for the user to handle in a productive manner. Now he doesn't need to open a form select the right combination of Customer and customerERP remember the ID and input that in mainform. It's all done automatically.

I finally did it.

Mike I figured that out and I was trying to find a way around it. What I want to do is let the user select DevCustID and CustomerERP by opening a form or subform, then find the ID (PK) from the table customer_joinT based on his selection, pass the value to a global var for example and then...

Pat I was clear about this "The main Table is AssetsT then we have CustomersT and CustomersERP. Forget about the rest of the tables." If you read my message I explain exactly where my problem is. I can't be more precise than this. I have included my db so you can look at whatever you want.

Well this is not the specific answer to my problem that I was looking for. You are not telling me which is the unnecessary table and why. What exactly are you proposing ? If we for argument say accept that these are the tables is it not possible to do what I'm trying to do ?

I agree with what you say Pat. I was trying to keep it simple cause most might have a hard time following my case that's why I tried to be specific to the solution I want to apply so I could get an answer.But since you want to know I'm sending my db striped of most unnecessary stuff. The main...

What I'm trying to do is a little more complicated. I have transformed that example to show you what I'm trying to do. So I made Table1 who will hold the "bookingsID" which should be a unique number pointing at tblBookings. The idea is that through the frmTable1 the user can select a CustID ...

ok found the solution :) I was trying to use/change the PK of the table customer_JoinT linked to the subform but I should have used the custID in AssetsT and make this a combo box So now I will need to make a new form for the user to change/add new customers in table customer_JoinT.

I downloaded the db and they work fine for me. I got Access 2016 I was planning on changing the relationship of customer_JoinT and AssestsT. It should be the other way around. I will also keep in mind what you said and my change fixes that issue also. New relationship is this. Removed the...

Nice ! That was the problem. Thanks a lot :)

Thx for the effort Mike but as I explained your suggestion to delete the query is not helpful for me since that will remove the function that I'm trying to implement.

Any suggestions on how to solve this problem ?

This is funny. I don't get the pop-up window when the sFrm_customer_JoinT is open as standalone which means that the subform inside the Frm_Assests is looking for the combo box data from the form outside not the one inside as a subform. Why is that ?

I don't have an issue with it. When I select a customer I get the correct match below on the CustomerERP

Why is it working on sFrm_customer_joinT when you run it ?

It's the customer_joinT that shows the relationship. customerERP can have many DeviceCustomers but not the opposite. So when user selects DevCustID it will update the list of possible selectable custERPID. That's why the query is needed Keep in mind that it works fine if you run the...

The query is for the cbCustERP combo to populate according to what is set in cbDevCustID combo. You must not delete it

I thought it's not good to open many threads when there is already another relevant That's my understanding so far, I'm glad I got this right ;) Data entry will be a pain for me that's why I need to experiment and make sure I understand everything beforehand. Imagine that I have to pull data...

I must have messed something in my db that gives me a popup window The sFrm_customer_JoinT works fine on its own but in the subform it seems it has an issue. The value from the cbDevCustID which is asked is supposed to update as soon as the Frm_Assets is loaded and then the combo cbCustERP...

nice thanks!