Re: Tables Relationsship

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is there a special use for TableB that precludes your use of the data in
TableA to know which serial numbers have been issued? TableA will already
contain that information.

You haven't commented about when you are doing this? Are you using a form?
--

Ken Snell
<MS ACCESS MVP>


"Shariq" <Shariq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20CBEFD7-1EFE-4824-9172-2C0C20846B39@xxxxxxxxxxxxxxxx
> Here is the details.
> The master table TableA is a huge table that contains product information;
> the column name for product name is Item and it is a key field. TableB
> contains serial numbers for each product and are incremented as a product
> label is printed from within the application. When a product label is
> printed, I want to write serial number for that product to TableB which is
> not availabel to the users. The user will add new records into TableA and
> at
> that point I want to automatically add that Item number in TableB.
> I hope this explains what I am trying to accomplish.
>
> "Ken Snell [MVP]" wrote:
>
>> Not possible directly from table. You need to use a form to add data and
>> then the form can be programmed to add data to another table.
>>
>> Of course, I must ask... why do you wish to store apparently redundant
>> data?
>> Or are there more details about this setup that are not obvioius to us?
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Shariq" <Shariq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:EB4462A6-2C63-412E-8915-AF0D3392DCAF@xxxxxxxxxxxxxxxx
>> >I have two table; TableA and Table B. Both have a key field named Item.
>> > When I add a record in TableA, I would like it to add to TableB
>> > automatically. How do I do it?
>>
>>
>>


.

Relevant Pages

  • Re: Cursors (again)
    ... What does it matter if TableB is temporary? ... or tableA. ... open cTableB ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL: Working with huge tables of chronological data
    ... TableB is ~30 millions row and contains (timestamp, ... from tableA TA1 left outer join tableB TB on (TA1.timestamp < ... that portion of the plan was executed. ...
    (comp.databases.oracle.server)
  • Re: Dazed and Confused
    ... related to the records in TableB, *and* how EACH record in TableB is related ... to the records in TableA. ... Purchase Order Details Table to a Purchase Order Table ... Junction table to the Purchase Requisition table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL: Working with huge tables of chronological data
    ... TableB is ~30 millions row and contains (timestamp, ... from tableA TA1 left outer join tableB TB on (TA1.timestamp < ... the predicate information for ID 9 come from? ...
    (comp.databases.oracle.server)
  • Re: Subselect Query Problem
    ... tableA LEFT JOIN tableB ... the result (of the inner join), it is logically re-introduced into the ... result, but since nothing match in tableB, whatever comes from tableB is ... > is Table B that has the first three fields as the primary key, ...
    (microsoft.public.access.queries)