Prevent Duplicates Across Two Fields

  • Thread starter Thread starter Smartin
  • Start date Start date
S

Smartin

In this table relationship:

PayDates [1...many] Bills [many...1] Payees

What is the best way to ensure there is at most one Bill with the same
PayDate and Payee?
 
Smartin said:
In this table relationship:

PayDates [1...many] Bills [many...1] Payees

What is the best way to ensure there is at most one Bill with the same
PayDate and Payee?
Click to expand...

Never mind... I found it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create new record in a table not linked to a form 1
Calculate percentage and total multiple results 3
Find records in a field based on a date range - JCW 5
Update two tables at same time 1
SQL: Summing By Date Continuously? 2
Why doesn't this work? Please Help... 4
Filter Form by date 3
Only show field with date 2

Back
Top