Hi,
I am using a Flat form database with 36000 records and about 10 meg of space

I want to normalize it to make it a little faster, but my question is what happens afterwards with my code

Will the built in links between the tables work as is or do I need to open all the tables somehow

and when I open the thing on the web i use this sort of thing

<td><%=objPagingRS.Fields(3)%>&nbsp;</td>

<td><%=objPagingRS.Fields(4)%>&nbsp;<%= objPagingRS.Fields(5) %></td>

if <%=objPagingRS.Fields(3)%> is a sub table of <%=objPagingRS.Fields(4)%> how do I call it so it still displays

Hope this makes sense

Topshed