designing a form

C

chaitu7

hi,
i am beginner .i have three tables organisation,department,contact_person.i
have to create a form with these tables.users can enter their values in the
form and tables should be updated with those vales.can anybody help me pls.
thanks in advance.
 
J

Jeff Boyce

That's a fairly generic request, and most folks here in the newsgroups help
on specific issues.

In the absence of more a detailed, specific description, my first suggestion
would be to build a query that returns the information (from your table)
that you'll want to see on the form. Then build a form based on that query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

choti

hi,
thank you for your reply.
i have values in organisation table.users can select their organisation
from existing values and enter their department ,contact person values in the
form.and tables should be updated with those values.with your solution,there
will be duplicate values in organisation table.

for example:
if the user first enter like this order
1. organisation name org1
and depart....d1
and contact...c1,c2c3
2.organisation name org2
and deptatment....x1
contact.......cc1
and department x2
contact.......cccc1
3.organisation name .....org1
and department .....d7
contact ..... ccccccc1

there will be duplicate values in org table.i donot want that.i want unique
values.can you pls. help me with this.
thanks in advance
 
J

Jeff Boyce

Your situation may get more attention if you re-post it to the
tablesdbdesign newsgroup. I realize you want to jump ahead to the form, but
from your description, your data structure is not set up in a way that
Access can easily use.

It sounds like you have organizations, departments and contact persons -- in
a relational database (like Access), that implies a minimum of three tables,
not one. And depending on the relationships (?how many "contact persons"
can a department have?), you may need more tables.

It all starts with the data. Please describe more specifically what data
you are working with.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

choti

hi,
thanks for the reply.
i have 3 tables called organisation,department,contact_person.
organisation table has 20 records.every organisation has few
departments.every department has few contact_persons.
i am linking tables like this.


org_id org_name
1 org1
2 org2


dept_id org_id dept_name
1 1 dept1
2 1 dept2
3 2 dept3
4 2 dept4


c_id dept_id name
1 dept1 c1
2 c2
3 c3
4 dept2 c4


i want to create a form for users to enter
their dept_name and name and org_name .
the tables shoulbe updated with those vales.
i want provide org_name to users using combobox.
using the org_name in the combo box,
the users should update their dept_name and name.
i want to create this in one form(using subforms).
can you pls help me.
thanks in advance.
 
J

Jeff Boyce

If one organization can have many departments, you need a table to show
that, in addition to the organization table and the department table. If
one department can have many contact_persons, you need a table to show that,
in addition to the department table and the contact_person table.

If you don't have these, creating forms will be much more difficult.

If you do have these, you can use main form/subform construction.


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

choti

HI,
THANKS FOR YOUR REPLY.
I HAVE 4 TABLES.TABLES ARE ORG,DIVISION,ADDRESS,CONTACT_PERSONS.ONE ORG CAN
HAVE MULTIPLE DIVISIONS,MULTIPLE ADDRESSES,MULTILE CONTACT_PERSONS.
ONE DIVISION CAN HAVE MULTIPLE ADDRESSES,MULTIPLE
CONTACT_PERSONS.CONTACT_PERSONS CAN HAVE MULTIPLE ADDRESSES.I NEED TO CREATE
A FORM SO THAT USER
CAN ENTER ORG,DIVISION,CONTACT_PERSONS,ADDRESS DETAILS AND TABLES SHOULD BE
UPDATED BY THOSE VALES.USER CAN ABLE EDIT THESE DETAILS.I DONOT WANT
DUPLICATE VALUES IN TABLES(EX:ADDRESS).IS IT POSSIBLE?IF SO HOW??

THANKS IN ADVANCE.
 
Top