Database Design

Hi All
I am new to this discussion group and Access 2007, so please bear with me.
I am designing a database for my wife, who recently got into using coupons
at grocery stores. She was having trouble keeping track of all the coupons
and what stores the sales were at, etc.
I set up two main tables, one for "coupons", and one for "Store Sale Flyer
data." Unfortunately I couldn't determine a primary key in either table other
that the autonumber ID field. I created a join to the tables in the query
using brand and item description as the relationship ties. (and set up the
proper join parameters for each)
It generally works, but I'd like the result to show ALL sale items, and then
match up any coupons that match, but I only get the specific matched records.
What am I doing wrong?

I figured it out, I was using one criteria on a date field, but didn't allow
for null fields!!! thanks anyway

"Kdata" wrote:

Hi All
I am new to this discussion group and Access 2007, so please bear with me.
I am designing a database for my wife, who recently got into using coupons
at grocery stores. She was having trouble keeping track of all the coupons
and what stores the sales were at, etc.
I set up two main tables, one for "coupons", and one for "Store Sale Flyer
data." Unfortunately I couldn't determine a primary key in either table other
that the autonumber ID field. I created a join to the tables in the query
using brand and item description as the relationship ties. (and set up the
proper join parameters for each)
It generally works, but I'd like the result to show ALL sale items, and then
match up any coupons that match, but I only get the specific matched records.
What am I doing wrong?