Creating Database with yes/no information

[Guest]

Hello,

I am looking to create a database of vendors that have a particular item.

I have an excel spreadsheet which has a list of stores carrying a certain
kind of dress and I also have a table already created in access showing a
list of all sotores in the region. I want to create a table which shows all
stores in the region and gives them a 1 if they have that kind of dress and a
0 if they don't. How can I merge these twopieces of data to get that result.

 

[Guest]

What you are trying to do is use Access as a spreadsheet. You should not do
this.

You need two tables - store and dress. Then set a one-to-many relationship
between the store and dress tables using a junction table.
STORE --
StoreID - autonumber
Phone - text
FAX - text
URL - Hyperlink or text
Name - text
Addr1 - text
Addr2 - text
City - text
State - text
ZIP - text
ZipPlus text
InActive - Yes/No

DRESS --
DressID - autonumber
LotNum - text
Style - text
Size - text
Color - text
Trim - text
Price - text
InActive - Yes/No

StoreDress --
DressID - number - integer - many side from DRESS table
StoreID - number - integer - many side from STORE table
InActive - Yes/No
StockDate - datetime
StockOut - datetime

For data entry use form/subform.