Recent content by pli

Hi everyone, I am curious if I can copy the entire last record in a table with a macro. I'm working with web forms and Sharepoint so I can't use vba or append queries (a total pain). The system limits me to using macros which is pretty inflexible (In addition, its not the full suite of...

I don't know what I did but it works now. The SQL query is exactly the same character for character and the relationship is defined but not an error in sight. If I figure out what I did, I'll post it here (or could just be a Microsoft thing, who knows?). Thanks for the assist!

I'm modeling the system with an Access backend as a proof of concept and if it gets the go ahead, it'll convert to an Oracle backend. Thats the wierdest thing though, and the part that quite confounds me. If the relationship between the two tables does not exist, the append to "bioreactor"...

Thanks for the assist. It is most appreciated. Here is the requested SQL script: INSERT INTO bioreactor ( CCID, dt, [Time], station, brxlot, cellday, titer, cd, viab, acd, glucose, cellbleed, perfusion, CSPR, harvest, media, base, recordcolor, notes ) SELECT DMax("CCID","cellculture") AS CCID...

Hello, I'm trying to do a self append to copy the last record entered. However I cannot use the append because of a key error (the query does not include the tables' primary key) created by the a relationship stating a field is a foreign key. The relationship is one-many so the duplication of...