Insert data into table

[smartstuff1282]

I'm very new to Microsoft Access so this question probably sounds pritty basic. I created a data base with a list of customer account . Some times I have to change the order of the Customer accounts listed but when I right click on the place where I want the new record to be listed so I can insert the accounts between the other records it goes to the top of the list of accounts. How do I insert the new account in between the other accounts without the new record automatically going to the top of the data base records.

 

[ZmrAbdulla]

Hi smartstuff1282,
You can't insert a record in between other records like you do in Excel. But you can sort it. click on the field and click sort button form the menu.
Regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[smartstuff1282]

Thanks for your help. I run a business where I do jobs in the same area so I create a route with the jobs that I do in that area. There are quite a few different areas that I do the jobs in so when I gain a job in the one area I was trying to go back and insert that new job into the area that I'm doing all the other jobs. I tried the sort feature but it still can't put the jobs in the order that I want them. The only other way to do it that I've found is to have to mannually retype the whole order of accounts or copy and paste them. Is there an easier way to do this?

 

[PHV]

What is the structure of the underlaying table(s)/query ?
What is the wanted jobs order ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZmrAbdulla]

Hi smartstuff1282,
It should be quite simple if you use a master table of areas and a sub table contains of job.

Table structures will be something like this

tblArea			         tblJob
				     JobID (P K)
AreaID (PK) ======>	AreaID (One to many relationship)
AreaName			   JobName
				      More Info...
				      More Info...

Create the masterform with table Area and Subform with table Job. Connect both

Link Master Field = AreaID
Link Child Field = AreaID
Come back if you are unable to …

Regards


Zameer Abdulla

http://www.geocities.com/zameerabd/