Setting default value in a column (1 Viewer)

[rainman89]

Or are you talking about just setting up all of my tables and then removing/adding/updating data?

yes!!

 

[crownedzero]

I'll give it a shot but it kind of opens up a whole other 'can of worms' I'm unfamiliar with. But at this point everything is pretty new

 

[rainman89]

I'll give it a shot but it kind of opens up a whole other 'can of worms' I'm unfamiliar with. But at this point everything is pretty new

It's easier then recreating the tables everytime!! Thats for sure

 

[crownedzero]

Well, it was recreate the tables OR delete all the data stored in the table and then update it.

 

[SOS]

Well, it was recreate the tables OR delete all the data stored in the table and then update it.

Which IS the better thing to do - delete the data and then append instead of recreating the table each time.

 

[crownedzero]

So I have three tables now.
Inventory
Prices&SKUS
and the blank report with all the report specific fields.

At this point, stop me if I'm wrong , I need to run a query to select the styles I need from the Inventory report and make a seperate table. Then I need to update the blank report with this information, correct?

 

[SOS]

So I have three tables now.
Inventory
Prices&SKUS
and the blank report with all the report specific fields.

At this point, stop me if I'm wrong , I need to run a query to select the styles I need from the Inventory report and make a seperate table. Then I need to update the blank report with this information, correct?

I'm wondering why you think you need a table for a report. You just use a query as the underlying recordsource for the report and you have just bypassed an unecessary step.

 

[crownedzero]

The query is run against the Inventory file which doesn't contain half of the information I need, I've attempted running a report but it has come up empty.

 

[SOS]

The query is run against the Inventory file which doesn't contain half of the information I need, .

Where's the other half?

 

[crownedzero]

Inventory table: (imported from Excel)
UPC
Item#
Type
Size
Width
Price
Available

Customer specific table:
UPC
MerchantSKU
Price

ItemAttrib table
(Might need to add UPC)
Item#
Description

Report table: (final output needs to have all of these)
Filetype (Always "IN" for Inventory)
UPC
InStock(Yes/No based on "Available" from Inven.)
Available
NextShipDate & Qty ( Blank)
Manufacturer (Blank)
ManufacturerSKU (Blank)
Description (ItemAttrib table)
Unit Cost (Price from Customer specific)
UnitCost2
UnitCost3
UnitCost4
Deactivated(Y/N based on "Type" from Inventory)
MerchDept(Static #)
UoM(Static "EA")
MerchantSKU(Customer specific table)
Merchant(Static)

So I need to query the Inventory based on style and size and then get it into the report table and pull all the other relevant data from other tables in with it.