yasinercu
03-24-2007, 05:35 AM
i am sorry
im new using access
how can i make a table with code? and how can i create relationship between tables with using code?
boblarson
03-24-2007, 07:00 AM
don't post the same question in more than one category.
You can create a table with code, if you use a SQL statement (see tutorial here: http://www.1keydata.com/sql/sqlcreate.html) or you can create a make-table query in the QBE grid and save it and then call it each time you need it by using DoCmd.OpenQuery. As for relationships, I don't think you can do that programmatically, but I'm not sure.