Hi, Good morning to everybody in the forum:



1. Got emergency project which require us to build simple database using Access 2010. Let's say the company want to recruit employee - they can come forward using 3 options:

a) By own person - only 1 person at a time
b) Hire by a group of friends - can be more than 1 person at a time
c) Hire by company - can be more than 1 person at a time

So I want to build database to register all the workers that come in for interview, as I understand I need to use foreign key to do the selection (3 options give by drop down menu). But I don't know how to use the syntax... Please help

2. When we choose from 3 options - each represent 3 different sets of field for person/friends/company to key in contact detail:-

a) For each person - we only need to keyin once
b) For a group of friends - we need to key in each friend details
c) For company - we need to register company detail and each worker detail...

So my question is how can we display difference set of form based on selection given?

3. We are thinking of adding subform for each worker - for family details - in datasheet format - so any particular setting need to keep in mind..

That's all...Hope to hear u guy soon..Again thanks ...

Please help...