Results 1 to 7 of 7

Thread: pointer (2000)

  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    pointer (2000)

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> I need to point to a field in another table. Been so long, I've forgotten how to do it. It seems it was as simple as placing "pointer to [field]" somewhere but I can't seem to remember where. Please help! Laura

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pointer (2000)

    Laura,

    What do you mean point to another field? Is this in a query, a form, a report?

    We need a few more details to be able help you.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pointer (2000)

    Do you mean a lookup field? If you want to create a lookup field in a table, you can either set the data type for the field to Lookup Wizard... and follow the instructions, or click the Lookup tab in the lower half of the table design window, and set the Display Control property to combo box, then fill in the appropriate properties manually.

  4. #4
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pointer (2000)

    Sorry for the delay in answering and in the confusion. My problem is I have two tables that have some similar fields. I have tables T_Patients and T_Persistency. Both of them have fields for Pt_ID and RNA_ID. Pt_ID shows up on both of them but RNA_ID does not and I need it to. I looked back at my old database that I thought had the pointer I was speaking of but that was just something the instructor had us put in comments. I have the field name and attributes all the same for RNA_ID. I tried enforcing referential integrity but there are duplicates in the Pt_ID field so I can't.

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pointer (2000)

    If I understand correctly you need to build a relationship between the 2 tables. Due to the duplicate ID's you require a third table which has the ID uniquely and 1:n references between this 'central' table and the each of the other tables. (You may already have such a table in existance).
    However if the duplicate ID's refer to different patients (ie ID 1 is patient A in one table and patient B in the other) then you are in a lot of trouble as you don't have any unique ID to provide a link. That means work by hand for you to bring the data into a form that relations will work with (get a big pile of firewood, some matches and ask the original designer in for a chat).

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pointer (2000)

    There should be no need to have the same data field in two tables, even in the form of a "pointer". Use a query instead. Create a selection query based on both tables and join them on (probably) Pt_ID. Drag the fields you need to the display grid. This query can be used as record source for forms and reports.

  7. #7
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: pointer (2000)

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> Oh man, Hans. Why didn't I think of that! Been thinking too much lately, I suppose. Yes, that will work for me. I just need it for reporting purposes. Thanks, Laura

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •