Relationship Problems!!

  • Thread starter Thread starter LozzaBaby
  • Start date Start date
L

LozzaBaby

Hi,

I have a problem! I have made a pretty basic ordering database for
computer firm. Now the system consists of the following entities:

Customers (Customer Name etc)
Order (OrderNo, Dateshipped)
Order Line (OrderNo, ComponentNo)
Components (ComponentNo, Name etc)
System Builder (BuilderNo, Name etc)

The problem relationship is this. A order may be built by 0 or 1 syste
builders. A system builder may build 0,1, or more orders. This ha
resulted in a relationship table which I called builds.

So I now have Order table with a 1 to 1 relationship with builds, an
System builder table with a 1 to many relationship with builds.

Order No is the primary key of the builds table. With BuilderNo as th
other item in this table.

The problem is, as this is a may activity, in that it may or may no
happen, how do I get access to see the links I have made. I tried th
form wizard and selected all the relevant fields from Order and syste
builder tables, but it would not enter anything into the Builds tabl
where it needs to go!!

I then tried using the Builds table as the basis for a form whic
worked as it entered the order no into the order table, (Is thi
because of its one to one relationship??) But now when I enter an orde
I have to know the System Builder's No when I want to use their name!!

Any help would be really appreciated
 
create a combo box to display 2 fields...builderNo, and BuilderName.
Set the bound field of the combo box to builderNo. set the size of th
builderNo field to 0.0". This will hide the field in the combo box an
allow you to use the BuilderName field as a lookup for the number.
Noone will ever have to see the number. In the recordsource propert
of the combo box you can add to the end of the SQL statement Order B
[tblBuild].[fldBuilderName] and it will sort the combo bo
alphabetically
 
Back
Top