Importing with Relationships (1 Viewer)

[iam trying]

Access HELP!

I hope you can help me. I'm trying to create what I thought was a simple database. It will run locally on 1 machine. Here's what I cannot understand.....
I created two tables both tables I imported the data (Excel sheet saved as CSV
one table has two field A bid number (Primary Key) and name field, these fields are filled with data.

The second field contains An item , the Table location(Primary Key) and the item description.

Now here's my problem......
Why cant I create a form that has a look up filter by BId NumBER,with the Name field(Which works!) But then I want to enter the Item to the applicable Bid Number. Why does this not work? I want to call up a bid # then under item a list should appear from my Item table. Do you havew any Idea why this does not work?

 

[WayneRyan]

iam,

tblBids:
BidNumber
Name

tblItems:
Item
TableLocation
Description

The two tables have nothing in common. I think that
you need something like:

tblBids:
BidNumber - AutoNumber
Name

tblItems:
BidNumber - Relates to tblBids
ItemNumber - AutoNumber
TableLocation
Description

Then you can easily make a form that will behave like
you described. The BidNumber field relates the two
tables to each other.

I hope that that gets you started.

Wayne

 

[iam trying]

AUTO NUMBERS

Thank you for your help. I have another question, Okay I have a few questions...
Can I set the Bid NUMBER as a auto number, if I want to assign them myself? And do I need to create a relationship for the form I mentioned ? Again, I know these questions might seem simple, But I'm trying to learn access as quickly as possible

 

[WayneRyan]

iam,

You can't assign values to an AutoNumber field. They exist
only to give each record a unique ID. You could have a
BidID field (the AutoNumber) and also a BidNumber if you
need to enter numbers that "make sense" to you. You
don't even have to display the AutoNumber field.

As to your form, you will have a main form for the Bids. The
items will be on a subform. You can use the Master-Child
relationship in the subform's property to say that BidID (Bid)
is the Parent and BidID (item) is the child. Then Access will
keep your forms in "synch".

You can use Tools --> Relationships to define how your
tables relate.

Keep in touch,
Wayne