Search results

I am going to look into it; meanwhile here's how my relationships diagram looks like (I doubt you need help with the translation at this point), for someone experienced like yourself a quick glance should be more than enough. ht tp://img137.imageshack.us/img137/1723/relationshipsdiagram.jpg

Actually I don't have a products table yet. I guess I ought to go by the template jdraw linked earlier, though honestly that would mean also exporting the address field from the Customer table which is, well, holding all that. Is it really necessary? I'm not sure about it, while I can see the...

Thank you so much. It took me a couple minutes to figure out I had to modify the SQL for the join query as the design view wouldn't enable me to properly join the results (Crystal's advice.. always take a look at the SQL :)); besides, it's starting to look like a proper database, and I owe it...

I am supposed to migrate the region data from the customers.zone field to a dedicated table: is there a quicker way to populate the new table with the unique region names i've typed in so far? I have like a 1000 records on my tblcustomers and about 25 regions or so.

Gotcha. Therefore I should be able to arrange a query to do the dirty job for me and assign them in the customers table as an external key? I'm not sure I'll be able to, but I am certainly going to try.

Cool, thank you, though I'm not sure I'll need it because no new zones will be needed for the DB and so far I managed with a combobox with fixed entries (I doubt these are the technical terms for what I'm talking about, but I mean when a droplist opens and gives you a list of possible choices)...

Thanks for the welcome, and the reply :) So far I only have the two aforementioned tables on the database. The zone field in the Customers table holds related information. One customer can only be in one region, and there can be several customers in one region. The order can consist of many...

Hello, I'm new to the place as I am to Access, and this is what I'm trying to accomplish: I've created a table named Customers that stores various information, and has a primary key named IDCustomer. Then I created an Orders table (with a primary key named IDOrders) and set a one to many...