Search results

oh, yes forgot to mention that for each table I use a form to enter th edata.

Hi, The CUSTOMERS table is the "parent" in the relationship and has an autonumber as its primary key. The DETAILS table is "child" and it’s primary key is defined as number [Long Integer indexed(no duplicates)]. I related both fields with a one-to-one relationship and checked both cascade...

No problem! every opinion counts!!!;)

Many thanks CraigDolphin! well I managed to make the one-to-all relationship by creating a query as follows: from clients table I added only the primary_key field and from products table I added * field (all fields). No need to join the tables in the query. Then in the relationships I related...

Before posting to this forum I spent more than two days looking at the problem. I thought to create a relationship one-to-all it would be easy and just could not see it... The database is already working and this is an extra adding I was asked to make. A tabbed form with two pages, page 1 shows...

why confused? it's simple, each customer (old or new) gets all products in table B. Based on this relation other details are calculated...

If i understood your question well, a shown record that relates a customer (from table A) with all products (table B) will display extra calculated information next to each product. many thanks!

Dear Rabbie, Correct, this is the case as soon as a client gets register it gets all the products. Based on this relation we can personalize products for each client. And as I have written all these info are displayed in a tabbed form, 1st page shows the clients profile and 2nd page shows the...

YES, actually always get all the products. YES, when a product is added or removed from table B that chenge reflects to all customers. YES, they do change. Many thanks for trying to help!

Relating table B (products) with each customer is what we must have. Customers do not choose the products but they get all of them once they get registered! I wonder if someone else came acroos to the same problem...

Hi Boyd, tried what you suggest and it does not work... I am getting really concerned with this problem!

Dear Engineer, I followed your directions, it does not work. Actually it produces an indeterminate relation.... Did you try it and worked?

Dear Rabbie, i must have stored all products in a different table.

I developed my date base using the ms access template "contact management database". When I launch the data base immediately opens a tabbed form with 5 pages. First page displays details of the chosen customer (name, address, tel, etc), the second page displays ALL products from table B plus...

Table A is a list with more than 500 customers and has 20 columns, table B is a list with 10 products and has 4 columns. I would like to related all products from table B with each record (customer) from table A. When a new customer added then automatically must be related with all products from...

Hi all, I know the title of this thread is not correct but it accurately describes my problem: how can I create a relationship between two tables (A and B) where each line from table A links(relates) with ALL lines of B. I tried different ways using one-to-many relationships without success...

Thanks Linq, the Activate event solved the problem! Also, i would like to thanks Adam for the initial reply! Kind regards, Pavlos

Dear Adam, Thanks for replying. I typed me.requery in the On Got Focus field of the "Contact list" form but still does not refresh the form! Any further suggestion for solving it would be very much appreciated! Regards, pavlos

Hi, I use the "contact management database" template from access 2007. When the database opens both forms "Contact list" and "Contact details" are set to open in a non pop up mode. The database is set up to display tabbed documents. When I add a new contact in the "Contact details" form and...