RE: Form Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi Doogle,
Thanks a lot for the info. I have been able to add a new record by creating
one to many-relationship, but there are a couple of more problems.
I also assume the 'parameter value' you intend changing each time you use a
>particular 'job type' is a value in table 1. (**Your assumption is right, but there is a problem populating this field )
The code I'm using is to populate the Parameter Value field is:
=JobType ID.Column(12) (**number relevent to it's field)

Thanks Again
chett




Doogle wrote:
>Hi Chett,
>
>I'm not sure I se a problem here - let's be sure I've got the picture right!
>
>Table2 is linked via JobID to JobTypeID in Table1: two questions:
>(1) - have you set up the 'relationships' and set up the links as
>one-to-many?
>(2) - did you check/tick the box 'Enforce Referential Integrity'?
>
>I also assume the 'parameter value' you intend changing each time you use a
>particular 'job type' is a value in table 1.
>
>Therefore what I assume will happen is:
>(1) - you want to create a new record, so you call whatever event is
>necessary to do this (maybe a command button, maybe just using the navigation
>buttons, as you prefer!), and you get a blank form.
>(2) - whichever data you enter forces a new record on table1, and thus sets
>its keyID (I assume you're using an autonumber? occasionally there are good
>reasons not to, but usually autonumbers are fine).
>(3) - you can select the 'job type' from your combo. It doesn't matter
>whether that job has been selected before, for other records in Table1. And
>it doesn't matter what data is in the other 'table1' fields.
>(4) - therefore, you have a uniquely numbered 'job event' record - ie the
>keyID for table 1.
>
>I hope that's clear; please let me know if it was helpful, but also please
>let me know if I've either misunderstood your problem or not been clear
>enough in my reply!
>
>All the best from England
>
>> Hi!
>> Sorry the earlier post did not align the tables info right, so had to post it
>[quoted text clipped - 29 lines]
>> Thanks in advance
>> Chett
.

Relevant Pages

  • RE: Form Query
    ... Table2 is linked via JobID to JobTypeID in Table1: two questions: ... - you can select the 'job type' from your combo. ... > Job Parameter Notes1 ...
    (microsoft.public.access.forms)
  • SELECT QUESTION
    ... Table1 contains two fields. ... Field1 contains Unit ... table2 for the job type that matches in both tables. ... doctors. ...
    (comp.databases.ms-sqlserver)