adding new record when one field seems required

[Catherine Jo Morgan]

I have TblRoles and TblRoleTypes. The main reason for RoleTypes is to make
it easier to categorize roles for people and organizations. For example,
RoleType entries include Client roles, Climb Support Roles, Vendors, Media &
Publicity, Info & Training.

In TblRoles, RoleTypes is a FK but set as not required. Still, Access won't
let me save a new record in TblRoles if an ID# for RoleTypes is not entered.
I can fill in the table now by entering the correct ID number for the
RoleType for each new role.

But how will someone else be able to add a new role later? I haven't been
able to make a form that lets me enter a new role.

I tried making a form with roles as the subform, viewing the roles by
roletypes. But it stays with only the first roletype in view, so I can use
the form to add new roles only to that type. Maybe I should just go on
without worrying about this till I start making all the data entry forms?

[Kinetic - Paul G]

hi cath

option 1 - set up a role type of TBA - To Be Advised - use it as the default

do you have a relationship setup between role-type and roles ??

this could be forcing you to fill role-type

cheers
paul
"Catherine Jo Morgan" <cj******@hemc.net> wrote in message
news:x6********************@hemc.net...

I have TblRoles and TblRoleTypes. The main reason for RoleTypes is to make
it easier to categorize roles for people and organizations. For example,
RoleType entries include Client roles, Climb Support Roles, Vendors, Media & Publicity, Info & Training.

In TblRoles, RoleTypes is a FK but set as not required. Still, Access won't let me save a new record in TblRoles if an ID# for RoleTypes is not entered. I can fill in the table now by entering the correct ID number for the
RoleType for each new role.

But how will someone else be able to add a new role later? I haven't been
able to make a form that lets me enter a new role.

I tried making a form with roles as the subform, viewing the roles by
roletypes. But it stays with only the first roletype in view, so I can use
the form to add new roles only to that type. Maybe I should just go on
without worrying about this till I start making all the data entry forms?

[Catherine Jo Morgan]

Yes, there's a one to many relationship between role type and role, with
relationship integrity checked. I was reading something today that gave me
the idea that I could just make the "0" stand for some entry in the Role
Type table - like "Not Set Yet" or "None."

Actually, it's OK as is except that I haven't been able to figure out how to
make a form that lets a user select among the role types, then add a new
role. Maybe when I study forms more I'll figure this out. This is really
what worries me. Thanks!
"Kinetic - Paul G" <ki*****@alwaysonline.net.au> wrote in message
news:3f******@alwaysonline.net.au...

hi cath

option 1 - set up a role type of TBA - To Be Advised - use it as the default
do you have a relationship setup between role-type and roles ??

this could be forcing you to fill role-type

cheers
paul
"Catherine Jo Morgan" <cj******@hemc.net> wrote in message
news:x6********************@hemc.net...

I have TblRoles and TblRoleTypes. The main reason for RoleTypes is to make it easier to categorize roles for people and organizations. For example,
RoleType entries include Client roles, Climb Support Roles, Vendors, Media

&

Publicity, Info & Training.

In TblRoles, RoleTypes is a FK but set as not required. Still, Access

won't

let me save a new record in TblRoles if an ID# for RoleTypes is not

entered.

I can fill in the table now by entering the correct ID number for the
RoleType for each new role.

But how will someone else be able to add a new role later? I haven't

been able to make a form that lets me enter a new role.

I tried making a form with roles as the subform, viewing the roles by
roletypes. But it stays with only the first roletype in view, so I can use the form to add new roles only to that type. Maybe I should just go on
without worrying about this till I start making all the data entry forms?

[Kinetic - Paul G]

hi cath
your last problem is one I commonly have to "solve" . . except I solved it a
long time ago and now just repeat the method.

I nearly always create records by running an append query using SQL code.
Because most of the records I wish to create belong to some "parent" record
like your role-type. And i have never learnt how to code in SQL. . . I let
MSA query do the hard work. . .

create a query that does what you want it to do then disply the sql view . .
voila . . the code is there . . . copy it to your VBA code area and fiddle
it . . this bit takes a little practice . . it bit can be tricky but once
you understand the basics its quite easy and efficient

if you need an example I can email a form to you

cheers
paul

"Catherine Jo Morgan" <cj******@hemc.net> wrote in message
news:6L********************@hemc.net...

Yes, there's a one to many relationship between role type and role, with
relationship integrity checked. I was reading something today that gave me
the idea that I could just make the "0" stand for some entry in the Role
Type table - like "Not Set Yet" or "None."

Actually, it's OK as is except that I haven't been able to figure out how to make a form that lets a user select among the role types, then add a new
role. Maybe when I study forms more I'll figure this out. This is really
what worries me. Thanks!
"Kinetic - Paul G" <ki*****@alwaysonline.net.au> wrote in message
news:3f******@alwaysonline.net.au...

hi cath

option 1 - set up a role type of TBA - To Be Advised - use it as the

default

do you have a relationship setup between role-type and roles ??

this could be forcing you to fill role-type

cheers
paul
"Catherine Jo Morgan" <cj******@hemc.net> wrote in message
news:x6********************@hemc.net...

I have TblRoles and TblRoleTypes. The main reason for RoleTypes is to make it easier to categorize roles for people and organizations. For example, RoleType entries include Client roles, Climb Support Roles, Vendors, Media

&

Publicity, Info & Training.

In TblRoles, RoleTypes is a FK but set as not required. Still, Access

won't

let me save a new record in TblRoles if an ID# for RoleTypes is not

entered.

I can fill in the table now by entering the correct ID number for the
RoleType for each new role.

But how will someone else be able to add a new role later? I haven't

been able to make a form that lets me enter a new role.

I tried making a form with roles as the subform, viewing the roles by
roletypes. But it stays with only the first roletype in view, so I can use the form to add new roles only to that type. Maybe I should just go on
without worrying about this till I start making all the data entry forms?