[SOLVED]  Assign Contents of a table twice or more

This topic is locked

[SOLVED] Assign Contents of a table twice or more	6/27/2006 2:44:17 AM
PHPRunner General questions
D dieter author I have different Tables (Printers, Monitors, PC, Software and Users). There are some users, that have more then one Monitor or different kinds of software. is ist possible to show on an Master (users) more than one of the Monitors ? When I go to add I can add a new Monitor in the tabel monitors but I want to add an existing Monitor or a Software to this User. The other way round is, that for example, that 3 Users have 1 Printer so that I have to assign one printer or PC to more than one User. Is this possible or should I use MS Excel ? best greets


	Alexey admin 6/27/2006
	Dieter, if you need to store this kind of relationship in database you'll need one or more additional tables to keep Equipment-to-User links. I.e. create table PrinterAssignments with User and Printer columns. Put the following records there: User A - Printer 1 User A - Printer 2 User B - Printer 2 This mean that User A has Priners 1 and 2 and Printer 2 is used by Users A and B After you create these tables you can build a web interface for them with PHPRunner.