Table relationships and how they control a form with subforms...

[misscrf]

I have a database that I am building to keep track of when people apply for a job with our law firm. For a detailed explanation of

the db, please see post: thread702-964418 .

Right now, I am working on a specific issue. I have a toggle type option group. This option group is set to show and hide

appropriate tabs on a tab control within the form. Each tab has a subform. For this to make sense, let me explain the detail. The

main form is a candidate form, which comes from the main candidate table. The option group specifies the type of candidate. The

type may be attorney, HR, IT, paralegal, Administration and so on. Each option sets its appropriate tab and subform to be visible,

so that the user can enter in that specific person's candidate type specific information. My issue is that I have a candidate id on

each subform which is how the main form and subform are linked.

That sounds all good but when I view it, I see a number, and not the name of the candidate. I am not sure if I should make not

visible, or if there is a better method for showing the candidate name on the subform, as it is on the main form. I think I am wanting

to do this, maybe even for myself, to ensure that the subform is on the same record as the main form.

Any thoughts?

Something I am looking at now is the relationships between my tables. I have the candidate table, and then I have each candtype

table. My thought is that the cand ID should be enough, but I wonder if I need to somehow tie in the candidate type. The

candidate type gets stored in a candtype field in the candidate table, but each candtype table does not have any connection to its

type identifier. I have a candtype table to serve as the candidate type master where each type is defined. Do I need to somehow

attach this to each candtype table? That would be the attorney table, hr table, IT table...

If anyone is just soooo curious to see this db, please let me know I can zip it up and email it out or share it out on my yahoo

briefcase. I would love any help that can be given in organizing the set up of this.

Thanks.


misscrf

Management is doing things right, leadership is doing the right things

 

[HitechUser]

misscrf,

I am not quite sure of what you need, but you can display (reference) a control (or value) from the main form on your subform by using the "Me" or "Forms".

(I am doing this from memory...) I beleive the syntax is--

Forms.Mainform!ControlName
-or
Me.ControlName

Create a text control and have it's value be one of the above.

Sorry I am not near a machine with Access installed.. I hope I got you closer to your goal.

Good Luck...

 

[misscrf]

I think I should be able to get that control to show. I think a big question for me is normalization.

I have this db started, but I have someone on another post at another forum saying that this db isn't normalized. They claim that I shouldnt have a separate table for each cand-type info.

My question is, that if I am not supposed to do it that way, then how am I supposed to do this? I don't understand how to get this formed right, so that I can get this together. I want this db right from the ground up so that there are not problems.

Thanks for any help out there. Let me know if I can email you the db and I will.


misscrf

Management is doing things right, leadership is doing the right things

 

[lespaul]

You should first read The Fundamentals of Relational Database Design and get an understanding of what normalization is. Then, come back and post the tables that you think you need and have us critique them, make suggestions and additions. Once you have developed the table structure, then you can move on to form design.

HTH

leslie

 

[misscrf]

I'm a step ahead of you. I found a different post, but same thing. I am reworking my tables now. I will post back when I have my table structure set up, to what I hope will be 3nf or better.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[misscrf]

I have redone my entire database, and I believe it may be 3NF. Problem is that I would really like someone to look at it. I am looking for someone who can tell me if it is a good normalized db, and then where to go from here. Specifically building good solid forms.

Thanks for any advice. I don't want to post to another site, but I have my db zipped and with a jpg of the table relationships on one. I dont think I can attach stuff here. If anyone would let me email them I can send it that way too. Whatever works.

Thanks for any advice!

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[lespaul]

you're right, you can't attach a file to the posting and a lot of people don't like taking things out of the forum or posting email addresses (evil crawlers, you know!). Why don't you just tell us about each table and the fields in it?
For example:

tblPerson
PersonID (PK - Autonumber)
PersonFName
PersonLName

tblPositions
PositionID (PK - Autonumber)
PositionDesc

tblPeopleApplied
PersonID (FK to tblPerson)
PositionID (FK to tblPosition)

If you lay it out like this indicating PK and FK relationships, we can still help you analyze and suggest any changes.

of course, you may also get someone to let you mail it to them. Another option would be to put them on a web page and allow them to download from there.

HTH

leslie

 

[misscrf]

I have the file at another site...
let me know if this doesn't work for you. It is in my first post on this page, and it is called hiringDB.zip

http://www.access-programmers.co.uk/forums/showthread.php?p=343275#post343275

If that doesn't work, I might be able to temporarily post it on my class reunion site. I wanted to put it in my yahoo briefcase, but you can't share stuff unless you pay. Meany heads! lol

Thanks for any help. I would be happy to do the table list, but that would be A LOT of work!
Thanks.

misscrf

It is never too late to become what you could have been ~ George Eliot