Duplicate tables base on company id

[WicksWar]

I am building a single application that requires multiple companies. How do I access employee tables (for example - one for each company) using a grid that requires the table name in "Query (DBF) Table Name." Is there a parameter that I can prefix to the table based on the company id that the grid can identify? I need to keep a set of tables per company so I do not intermingle rows of data for all the companies.
Thank you
Mindfully
WicksWar

[Steve Wood]

Re: Duplicate tables base on company id

The normal design is to have one grid for each table. But you can do what you want IF both tables are the same structure. Like this:

Create your one grid based on one of the tables. Insert it in an A5W page for display. Now look at the A5W source. Note an area that looks like this (my component name is userlist and I have two tables, user1 and user2:

with tmpl_userlist
	componentName = "userlist"
end with

Change it to look like this:

with tmpl_userlist
	componentName = "userlist"
	if "A"="A"
		DBF.table_name = "[PathAlias.ADB_Path]\user1.dbf"
	else
		DBF.table_name = "[PathAlias.ADB_Path]\user2.dbf"
	end if
end with

Obviously my IF statement is just for test. As is, it will use User1.dbf, if the statement is false, it will use User2.dbf. So in your case you would maybe use a session variable in the IF statement to determine which table to use. If you have more than two tables, you might use a CASE statement.

By the way, thank's for the idea. I never though of this as an option until just now. It works quite well.

[WicksWar]

Re: Duplicate tables base on company id

This is great news. Thanks for the reply. I give it a try, but do not see any issues.

[DaveM]

Re: Duplicate tables base on company id

ken,

Another way. we been doing this for decades is to have 1 table with a designated field for the company. we have been using a numeric field with 2 spaces to accomodate up to 99 companies with 1 table. You just seperate the companies with this unique field. The 2 spaces was our own idea, but anything needed would work.