Access Problem Data not showing????

Question

I set up a Database and in one of the tables I set up two drop-down/lookup boxes based on information from other tables.  When I run the database it works fine on my computer.  However when I saved it to our server and even run from a "flash-drive" it will not work on other computers.  When I go to the drop down box it has three fields:  StudentID, Student LastName, StudentFirstName, but only the studentID numbers show up.  The last name and first name are not visible but the lines that delineate the fields are there, but no information.  This only happens on other computers not on mine.  Another drop-down on the same table also shows no information.  I created it using Access 2007 but I saved it as 2007 and the 2003 compatible form...both don't work on other computers.

I hope it is a simple solution....Thanks

Del Dobbs

Answer 1

I am not sure I understand what you are saying???  If I want to access a whole list of personal information from one table and use that information to relate to information in another table...what are you suggesting?  It sounds like you are saying that creating a table using information from two other related seperate tables using a wizard is not the way to go????  Could you explain further?

Thanks,

Del Dobbs

Answer 2

I hope it is a simple solution....Thanks

Do not use lookup fields in a table.  Better yet do not interface directly with tables, use queries, form, and reports.

Use a combo on a form for your lookup.

---

Build a little, test a little.

Answer 3

Table (InterventionRecords) does not need lastname and first name. Do not use the lookup wizard tool.

Create a one-to-many relationship between StudentInformation and InterventionRecords by adding a foreign key field to InterventionRecords.  The field must be number, long integer to complement the autonumber primary key field ofStudentInformation.  When building the relation set Referential Integerity and Cascade Update.

Use a form/subform for student/intervention setting the Master/Child link with student primary key field/intervention foreign key field.  Use a combo on the subform to select from theInterventions table.

---

Build a little, test a little.

Answer 4

I have two tables that are set up with "static" information (if I understand you meaning of static).

Table (StudentInformation)

ID -  AutoNumber

StudentID - Number

StudentLastName

StudentFirstName

Etc. (Demographic information)

Table (Interventions)

ID - AutoNumber

InterventionType

I want my third table to record the interventions that each student had throught the year.  I would think that it would look something like:

Table (InterventionRecords)

ID - AutoNumber

Student ID (From Student Info Table)

StudentLastName (From Student Info Table)

StudentFirstName (From Student Info Table

Intervention (From Intervention Table)

InterventionDate - Calendardate

InterventionLength - Time ex.  15 minutes, 1 hour, etc.

Comments-   Memo

(The info from the other tables; ID, lastname, first name, and intervention would be taken from the first two tables using the lookup wizard tool)

That is my plan...It sounds simple to me

Thanks

Del

Answer 5

I set up a Database and in one of the tables I set up two drop-down/lookup boxes based on information from other tables. 

It sounds like you are interfacing directly with tables.  Are you using forms for data entry and retrival? 

You should have one table with static personnel information with a primary key field.  Related tables should in turn have a foreign key field and a one-to-many relationship.  Then use a form/subform for individual/related data whith the form/subform Master/Child links set on the primary/foreign key fields.

If you do not follow what I have said then describe how your tables are related and you business practice that you are trying to accomplish.

---

Build a little, test a little.