-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Access2000 updating data
- Thread starter kola
- Start date
thank you for your reply!
i already have them linked.
if i understand you correctly you mean to create a relationship between the corresponding tables, right?
let me make this a little bit easier.
i have 2 tables Orders and Customers with relationship using primary key from the Customers table to respective field in table Orders.
when i enter new data in Orders (suppose i have new customer that isn't included in Customers). so i have to open Customers table then enter the new customer data and then close the Orders table to open it instantly after that because only then i see that the new Customer is in dropdown box in Orders table.
i don't know. i suppose the lookup is the core of the problem. what do you think?
i already have them linked.
if i understand you correctly you mean to create a relationship between the corresponding tables, right?
let me make this a little bit easier.
i have 2 tables Orders and Customers with relationship using primary key from the Customers table to respective field in table Orders.
when i enter new data in Orders (suppose i have new customer that isn't included in Customers). so i have to open Customers table then enter the new customer data and then close the Orders table to open it instantly after that because only then i see that the new Customer is in dropdown box in Orders table.
i don't know. i suppose the lookup is the core of the problem. what do you think?
Upvote
0
