I made a template using tables and when I paste it to a web page the top part
of it isn't aligned correctly.  I used to different tables.  I can't move it.
any suggestion would be appriecated.
thank you

I have not been able to get much of a response to this problem. Please help
if you can. Can I use referential integrity and have one table on the many
side joined to more than 1 table on the one side?
for example can i have a table called photo joined to tables "sample" and

I want to create a LName (Last Name) field that contains all PRE-INPUTTED
data into another table without having to re-type the information.  I thought
taht using the expression builder to creat the expression linking the two
tables and fields together and setting them equal to ...

I'm using Access 2003 with the perl DBI interface.
Perform the following steps:
(1) Search for a record using "SELECT ... WHERE...".
(2) If I cannot find it, I start a transaction and then I use "INSERT ..."

Good day,
Wow, one more question - as you can see I am certainly no expert here.  I
set-up a database and created a memo field purposely so that I could put more
than 255 characters in it.  After using the database for sometime we've

Mostly I've been able to have complete control of table design on projects
I'm a part of.  But recently I got a project *just* to add an ASP front end
for a database.  The design of the tables is horrible, and will cause lots
of extra work for me.  I'd think it has already cost ...

An Access 2000 database table has a field of type Date with no default value.
The table is being populated by another process that I'm not privy to.
Somehow, there are many records in the table that have no date component in
this field, just a time component, "12:00:00 a.m.". ...

What is the purpose of setting FK's (from other tables) as Primary Keys in a
Junction table?  What is the purpose of setting multiple PK's in the Junction
table?
Thanks....b

Hello, I have created a database including all students who have applied for
admissions at my school.  I have included 4 fields that give the student a
"score" between 1 and 4 corresponding to their abilities in several different
areas, i.e., essay, GPA, assessment exams, and ...

I have 2 Access 2003 databases will call A (client) and B (physician).  Each
of these have 2 main tables, Table A and Table B.  I have linked the 2
tables.  What I would like to do is on the client data entry screen, when
they get to the physician question, that when they start ...

I'm working on a db of our companys Items.  So far I have;
tbl Items - ItemID (pk), Item Name, Item Sales Price, etc
tblVendor - VendorID (pk), Vend Name, Vend Phone
tblItemsVendor - ItemID (pk), VendID (pk)

Is is correct that subdatasheets don't work when the tables are attached?
When I open the backend mdb that has the tables, it works (works = the little
plus/minus sign is visible). When going via the "front-end" mdb to which the
tables are attached, no plus/minus sign. Is there ...

I am designing a database to track revenue generated at various sites from
various programs.
I have the following tables: Sites, VPs, Programs, Revenue Categories(eg.
other, Ancillary), Revenue Classes(eg. goods, services, other), and Revenue

I'm trying to setup a database of our company items.  Some items have more
than one vendor.  I'm not sure how to link more than one vendor to an item
I have:
tblItem

I have a lookup field in my table looking up values from another table.  It
works in the table, it works in the query but in the form it only shows up as
a combo box, when I want a drop down list.  I have deleted that control and
tried again, all to no avail.