Hello,

 

New User - A Real DB Novice.

 

I have created 2 tables 1 = "People" 1 = "Assets", the forms appear to work fine, 90% complete.

I have 2 questions?

 

1. I need to create a unique UID 4 digit, sequential number starting at 1000 on my People Form.

    So when I add my first record in Form Unique = 1000, next 1001, next 1002 so on.....

    I have searched and seen some example creating new form with 1 field and some script on success??

    Is there no easier way?...     I'm very new to this remember :)

 

2. I'm getting confused with the 1 to Many and Many to 1 and 1 to 1 ???

    I think I need to do the following to link Assets to People

    On my Asset Form I have created all the Asset details, But I need to add a field for "Assigned To:"

    I want to add a "Drop Down" list, and select somebody from the People table?

    1 Asset linked to 1 person, But a person can have Many Assets, so I will just do this for each Asset

    Also I need to be able to see the above Unique ID when selecting, Just in case we have 2 names the same..!!

   

   What I mean is the Drop Down shows me FirstName..LastName..UID,

   When I select one it just shows First Name, Last Name in the Field,

   But relates the Asset to Person via the UID?

 

Hope this makes sense?

Any help appreciated

 

Many Thanks

David