next step

[nevje]

database is for tracking mobile phone user info over time and which
individual internal contract number it is charged to. i currently have 3
tables and 1 data entry form to add/edit this:-

Tables
MainData
Models
Contracts

Form
MainDataForm

im stuck at how do i move on from this. i want to track additional users
over time so when i add/edit a user who is currently setup i want the
old details to move somewhere else so i could list a phone number and
get a list of users who were issued this number and the dates they held
the phone for.

im just not clear on how to take the next step, can anyone point me the
right direction?

 

[JulieD]

Hi

need a bit more info

in your MainData table do you have your mobile phone USER's details (name,
address etc)
is this linked in a one to many relationship with your Contracts table
(where you hold details of the USER and the MODEL of phone they have with
DateTo and DateFrom)?
and does your Models table list the phones you have available for the user's
to use and is also linked with a one to many relationship to the Contracts
table.

if so, then you have the set up you need to achieve what you're after, if
not ... this is the sort of thing you need to do:-
one table to hold the user's info
another table to hold the phone's info
a table to link them together (with a date to & a date from)

please post back if you need further assistance.

Hope this helps
Cheers
JulieD

 

[Marc]

Tables
MainData
Models
Contracts

Form
MainDataForm

Without the details of the files it is hard to say. But as a general
principle you should have
Customers - all the details that only relate to the customer and don't
change over time - ok to call it MainData
Telephone - customerID to relate to the customer file, telephone no and
start date and end date, and model id - this may be what you call contracts


Then you make a form of telephone.
You make the form of MainData
Then you insert the contract form into the MainData form as a subform with
the customerids being the link

Then you need a query - with the Telephone table and the customer table
linked - which you can do through the wizard.
Then in the query builder you add in the criteria:
under Telephone number: [Enter the number looking for]
under StartDate: [Enter start Date]
under EndDate: [Enter end Date]

This is the most straightforward way, but you may prefer to do it in a form.
HTH
Marc