RE: Form Query

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

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


--
Laury Burr a.k.a. Doogle


"chett via AccessMonster.com" wrote:

>
> Hi!
> Sorry the earlier post did not align the tables info right, so had to post it
> again. I have been trying to build an automated schedule using tables and
> forms.This is how they are laid out.
>
> Table 1 (updatable)
> Job Event:
> Job Event Id (Primary Key)
> JobType ID (Foreign Key)
> JobName
> Job Parameter Notes1
> Job Parameter Value1
>
> Table 2 (Cannot be updated)
> Job Type:
> JobEvent ID (Primary Key)
> Job Name
> Job Parameter Number1
> Job Parameter Default Number
> Job Parameter Description1
> Job Number (Integer) (not sure if I need this field to save a job more than
> once)
>
> Form
> Weekly Processing Schedule:
> I have a combobox "Job Type ID" calling the Job which fills in the other
> fields on the form. The problem is I would like to use a particular job from
> the combobox(listed only once) more than once and change the parameter value
> and save the record with a different Number. Please help as this is very
> important.
>
> Thanks in advance
> Chett
>
>
> --
> Message posted via http://www.accessmonster.com
>
.

Relevant Pages

  • RE: Form Query
    ... Hi Doogle, ... >Hi Chett, ... >- whichever data you enter forces a new record on table1, ... >- you can select the 'job type' from your combo. ...
    (microsoft.public.access.forms)
  • Form Query
    ... I have been trying to build an automated schedule using tables and ... Job Event Id (Primary Key) ... Job Parameter Notes1 ... I have a combobox "Job Type ID" calling the Job which fills in the other ...
    (microsoft.public.access.forms)
  • Form Query
    ... I have been trying to build an automated schedule using tables and ... Job Event Id (Primary Key) ... Job Parameter Notes1 ... I have a combobox "Job Type ID" calling the Job which fills in the other ...
    (microsoft.public.access.tablesdbdesign)
  • Form Query
    ... I have been trying to build an automated schedule using tables and forms. ... Job Event Id (Primary Key) ... Job Parameter Number1 ... I have a combobox "Job Type ID" calling the Job which fills in the other ...
    (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)