I want to create a table which has at most 7 records linked to each master
key.  If an 8th record is to be added for a key, I would like the oldest to
roll out of the table.
Is there a way to do this without writing code to bump through the table

I need to create a large Access lookup table.
The table will be roughly 2500 records consisting of 12 fields.
The entries into the table can be created with simple equations and a
few nested loops. I was thinking about using VB6; but wanted to get some

I have inherited a db with three tables, Adults, Youth and Persons. The first
two each have a one-to-one relationship with the third. I asked the designer
why the third, and was told that it was because Adults and Youth have name
and unit # in common (the adults are not ...

Rather than reinvent the wheel, I would like to know if there are searchable
consultant database designs out there that I could either use directly or
modify to use in our environment.  The requirements are not complex, but I
would be surprised if there is not a free (or low ...

When I try and register new persons in a database of mine it says:
Constants, fixed length strings, arrays, user-defined types and Declare
statements not allowed as Public members of object modules
Probably it is difficult to say what it wrong in my database. But if you

Wht is better using lookup on the table design, or to use combo thru form in
entering data.
I do not know the difference between this 2 method
Thanks in advance

I have a switchboard form in my database. Is there a way to create something
like an executable file for this switchboard and the database so that someone
using it doesn't have access to the table design, query design, etc.? How do
you typically package a database for use by ...

I have never dealt w/ a composite key before. I have a table with primary
keys of itemsku and date. Does this Composite Key guarantee that there will
be no duplicates?
thanks.

I have a person table that has id, firstname, lastname, address, city, state,
zip. I have set all fields except id to have required = no and allow zero
length = yes. But when I try the following query it will not insert the
record because the firstname is not filled out. Any ...

The database that I am designing is to track documents done in a Word
Processing Center.  There are 10 tables in the design.  I created a Form from
the Main table.  There is an Attorneys Table where the Attorneys ID is the
primary key.   Each record in the Attorneys table have ...

I'm hoping that my tables are normalized properly, but I'm stumped on a
particular layout and design structure.
I hav a table with faculty, which is always on the (1) side of several other
tables, which are the (many) side.  Faculty are activities tracked annually

I have two tables table07 and table08 one has data for 2007 and the other
2008. What I need to do is to take the information from both tables that
matches and put it into a big table for a report. The problem is that some of
the data is only for 2007 and some only for 2008 but the ...

I am in a case that a image and some texts should be best saved as a record
into a
table and can be retrieved back in a win form. I am wondering how to do the
image operation with database both in Access and SQL Server2005.

I have three tables, one for vendor ID, another for centerID (which
identifies country business cost location) and one for invoice information
identfying description,costs ,location id and code used for invoice. All
tables work well and have refrential integrity including forms ...

I am trying to create an access database that will show upcoming appointments
with clients. These appointments are always recurring every month, 3 months,
or 6 months. I would like to enter the appointment and client information
into a table one time and then see the appointments ...