Re: You cannot add or change a record because a related record is required in table tbl_Location

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I cannot thank you enough for you help. I do have another question. Maybe you can give me some direction. I have seven tables (Computers Laptop
Printer Peripherals Monitors and Location. The locations table has a one to many relationship with the (Computers Printers Peripherals and Monitors)
table. Laptops do not because we are more concern about user info. Computer most of the time have more than one user (Different Shifts).
My Users table has a one to many relationship with the (Computers Laptop and Peripherals)

The User table consist of several fields

Table: tbl_UserInfo

Name Type Size
UserID (PK) Long Integer 4
User_FName Text 50
User_LName Text 50
User_PhoneExt Text 50
User_CellPhone Text 50
User_Pager Text 50
User_Email Text 50
LocationID Long Integer 4 (Not used yet)
ComputerID Long Integer 4

The problem is when I use a form to link a Laptop, Computer or, Peripheral to a user I need to know the if the user already have and ID number if so
what it is. Is there a way to handle this differently? For instance since names are easier for people to deal with is there a way to type in the users
name and it retrieve the UserID and if they don't have one add the users required info and generate a user ID.


Thanks
.

Relevant Pages

  • Re: working with two computers?
    ... heron stone wrote: ... the laptop was enough for everything. ... The peripherals are all either wireless or connected through one ... So i have to use my old computer at a server... ...
    (comp.sys.mac.system)
  • Re: working with two computers?
    ... software maintenance hassles: the laptop was enough for everything. ... The peripherals are all either wireless or connected through one ... larger capacity USB hub, so that the laptop disconnect/reconnect routine ...
    (comp.sys.mac.system)
  • Re: Bronzepunk
    ... :: reams and reams of money in the peripherals. ... Well, a laptop these days normally has 100 megabits/sec ethernet, ...
    (rec.arts.sf.science)
  • Re: Successful dapper drake install on Dell Inspiron 9400 Core Duo
    ... Everything works great, sound, peripherals, (including the media card ... this laptop is well supported by Dapper. ... In the file /etc/init.d/bootmisc.sh add the line for the resolution you need at the end of the ...
    (Ubuntu)
  • Re: Successful dapper drake install on Dell Inspiron 9400 Core Duo
    ... Everything works great, sound, peripherals, (including the media card ... the laptop I have has the Intel 950 Integrated graphics controller, ... this laptop is well supported by Dapper. ...
    (Ubuntu)