I have several of the same fields in two seperate tables: Shipping and
Receiving.
When a shipment goes out it has a RMA, PO# and a Serial# etc. These fields
are redundant in both tables. Is thier a way I can use these fields only once

I have a working database that I am "tweaking" and would like advice on best
practices for table design.  Scorecards are composed of multiple measures
often with multiple data types.  Currently I have a text field in one table
that holds the results of all our measures.  This works ...

For example
Field A = ID #'s
Field B = Characteristics from a drop down value list.
If [FieldA] = "32", then [Field B] Must be entered/selected (in the form)

Hi, I have a small homemade inventory database that work fairly good in
keeping track of my customers purchase'and payment. Recently I face a
situation like below and did not know how to structure my tables to
accomodate this changes.

I have a form that is posting a transaction amount straight to
tbl_transactions. I have a crosscheck on this same form
(frm_Transactions) that will not allow someone to post a transaction
that will bring the balance on a given loan below zero. It gets this

I have a very big problem.. I have a form that contains 6tabs.. salestab,
deliveriestab, suppliertab, creditor/receivablestab, disbursementstab and
inventory tab.. Now, my problem is, i want to merge the
creditor/receivablestab and suppliertab into one tab without destroying the

Am fairly new to Access and this is puzzling me. I have a form (obviously
tied to a table) that asks for several inputs in fields:
- Month 1
- Amount 1

The tables in my Access db are linked to SQL db's.
I need to make one of the fields Required.
In SQL I unchecked the Allow Nulls box, then I ran the link table manager in
Access.

I am looking to have a counter in my dynamic query.  I have a subroutine
incrementing a value but as soon as I scroll in the records, the values are
changing...
How can I make sure that a record stays with the same number (for the same

I need to be able to keep up with parts on my husbands truck..(or he does).  
I have already taken care of entering parts numbers, parts discription, &
notes.  I need to  have a column for parts on hand, that will update
automatically when numbers are entered in the columns for ...

I have a db that designed I actively work in.  I created the table and form.  
When my staff wants to search for a record, they have the form open, click
the field, do ctrl f to find it.  The problem I am having is that they are
not watching what they are doing and type over ...

I would like select from a list, for example Yes or No list.

I'm fairly new to Access development. I am working for the NHS and want to
populate tables with patient information that will be refreshed every week.
Hence the database will grow quickly, but the numbers will not be that large.
I want to produce a weekly report after the data ...

I am looking for a way to limit people from entering info in all CAPS. I
would like some help with the way to do this when the guys are entering
corporation names into our database via a form.  Our client table is made up
of individuals and corporations.  The >L<??????????? ...

I wonder if anyone can help. I have tried looking for the answer through the
help option and in many of the books I have, but to no avail..
I have several tables all relating to client information. I have split them
into tables as it is a lot of information. As each record will ...