Hi all,

Let's say I have two tables:

tblComputer
computername
description

tblUser
username
password

A computer can have multiple users.
A user can only have 1 computer.

How would a table look like if there were 3 users using 1 computer and I joined them?

Like this?

tblJoined
tblComputer.computername
tblComputer.description
tblUser.username
tblUser.password
tblUser.username
tblUser.password
tblUser.username
tblUser.password