Re: Archiving Records for Historical Tracking

Thanks for your time and the information, I will look closer in the mentioned
items.

pietlinden@xxxxxxxxxxx wrote:
If an item can be issued and returned multiple times, you can't use
just the itemID or whatever as primary key. You need something like
{itemID, issueDate} or something like that as a compound primary key.
Make friends with the Access Help. There's tons of stuff in there.
also poke through some of the sample databases.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200604/1
.

Relevant Pages

  • Re: Problem with Access concatenate query
    ... records in the final query. ... You probably need to INNER JOIN the tables, although on what column, I am not sure. ... PriceID -- Primary Key ... ItemID --- Foreign Key ...
    (microsoft.public.access.queries)
  • Re: Update address from one data Base to another
    ... query grid, and drag and drop some column names between the displayed ... primary key columns, start a new line below ON beginning with AND. ... ItemID -- Primary Key ... Prices AS P1 ...
    (microsoft.public.access.gettingstarted)
  • Re: Query troubles
    ... I also don't know what an inner join is. ... If you leave these instructions out of a query, ... PriceID -- Primary Key ... ItemID between the two tables. ...
    (microsoft.public.access.queries)
  • DataGridView is not updating in master/detail form
    ... ItemPriceID - Primary Key - Autonumber ... Item Price is the detail form using DataGridView. ... Another scenario is if I will not use the foreign key constraint and after adding a new record both in parent and child form the child form has a value of -1 in the ItemID. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Price Levels
    ... In your price level table, the ItemID should not be the primary key. ... should be a foreign key to the item table. ...
    (microsoft.public.access.forms)