Invoice Line Items

[SimonT]

Hi Guys,

I have upsized my Database project to Access FE with BE SQL2005

All tables converted fine and have set TIMESTAMPS for all tables. One of my
forms is for invoice process and am having a real problem with the line
items of the invoice.

To strip it right back and fix the problem, I have created 2 tables locally
lineitems2 and a local table for the products, products2. I then create a
form for the lineitems, with a combo select the products, and this works
fine

However, if I then change the tables to be the linked tables the form does
not allow me to add any records?

Can anyone advise or help pls

Si

[Max Right]

Si,

I had the same issue, take a look at this post
http://groups.google.com/group/microsoft.public.access.sqlupsizing/browse_thread/thread/d152fd7a920ea167#
hopefully it helps

[SimonT]

Hi Max,

Thanks for that, however, reading the posts has not shed any light on my
problem, my issue is just testing a simple form using a local table for my
combobox (cboProducts) and the form based on SQL tables (dbo_products and
dbo_lineitems)

PK and FK are all set, one thing I did do was to change a data type from
both table from 'money' to 'float' to see how this would work.

This is so irritating and has delayed my progress now for almost a week
trying to resolve this!!

argh

Post by Max Right
Si,
I had the same issue, take a look at this post
http://groups.google.com/group/microsoft.public.access.sqlupsizing/browse_thread/thread/d152fd7a920ea167#
hopefully it helps